Question: how to export table in oracle with data?
Answer: In SQL Developer, click Tools, then Database Export. ...  Accept the default values for the Source/Destination page options, except as follows: ...  Click Next. On the Types to Export page, deselect Toggle All, then select only Tables (because you only want to export a table).