Home » SQL & PL/SQL » SQL & PL/SQL » Export table as SQL query
Export table as SQL query [message #189239] Wed, 23 August 2006 15:25 Go to next message
Messages: 20
Registered: April 2006
Junior Member
Is it possible to export one or more tables (and if possible the data it contains) to a .SQL text file so that i can take it home and rebuild the table structure via the SQL statements?

Im using Oracle Sql Developer for Win2K3.


[Updated on: Wed, 23 August 2006 15:42]

Report message to a moderator

Re: Export table as SQL query [message #189327 is a reply to message #189239] Thu, 24 August 2006 03:02 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
You want to look at either:

1) The Export utility. This will export a table and it's contents into a DMP file that can be Imported into a different database.

2) SQL Developer or TOAD will both create table creation scripts and export data as a series of INSERT statements

SELECT DBMS_METADATA.GET_DDL('<object_type>','<object_name>')
   FROM   dual;
will get you the DDL needed to create an object.
Previous Topic: String Functions
Next Topic: date differences from one table
Goto Forum:

Current Time: Sat Oct 22 20:43:33 CDT 2016

Total time taken to generate the page: 0.07530 seconds