Question: how to export all tables data in oracle?
Answer:  Click Tools > Database Export.
 In the Connection drop down, select the connection from which you want to export objects. ... 
 Deselect the Export Data check box and Click Next.
 Retain the default values of all object types selected. ... 
 Click Next.
 ... 
 ...