Export table in Sql oracle

Asked By 10 points N/A Posted on -
qa-featured

I need help to export the tables in the SQL Oracle Developer so that the fields, tables, structure and data in the tables can be kept at other location. In case of any loss, the data can be imported.

SHARE
Best Answer by Bowl Louise
Answered By 0 points N/A #160025

Export table in Sql oracle

qa-featured

 

You can export any table information in to a flat file to any specific directory. Later if it requires restoring then you can load the flat file in oracle.

To create flat file visit and follow <http://www.exampledepot.com/egs/java.sql/ExportOracleTableToFile.html>

To load flat file in oracle visit and follow <http://www.exampledepot.com/egs/java.sql/LoadFileToOracleTable.html>

You can also export table in different oracle database. For that visit <http://searchoracle.techtarget.com/answer/How-to-export-table-from-one-Oracle-database-to-another>

Best Answer
Best Answer
Answered By 0 points N/A #160026

Export table in Sql oracle

qa-featured

Hello

You can export your database from Oracle Sql Developer intself, no need to use third party tools or links. Follow this steps: 

1. Go to Tools -> Database Export

2. Select which connection you want export and click Next

3. Review which information you want to export

5. Press Finish and then you'll have to set output folder where your exported database will be saved.

Check these images to get better picture out of this: 

I hope I helped you.

Login/Register to Answer

Related Questions