Export table in Sql oracle

Asked By jermaineporterr 10 points N/A Posted on - 08/22/2012

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.

• Status: Open
• Question Views: 972
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Oracle Database

Best Answer by Bowl Louise

Go To Solution

Answered By Mehendry Sayu 0 points N/A #160025

Export table in Sql oracle

 

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>

About Mehendry Sayu

Questions
1

Answers
22

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 08/27/2012
• Question Category: Oracle Database

Best Answer

Best Answer

Answered By Bowl Louise 0 points N/A #160026

Export table in Sql oracle

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.

About Bowl Louise

Questions
0

Answers
101

Best Answers
20

• Vote Up 0 Vote Down

• Posted on - 01/22/2013
• Question Category: Oracle Database