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.
Â
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>
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.
