Home » RDBMS Server » Server Utilities » Exporting two tables (oracle 10g)
Exporting two tables [message #334644] Thu, 17 July 2008 09:16 Go to next message
Messages: 153
Registered: February 2008
Location: CANADA
Senior Member

I want to export two tables data into another data base tables .
It contains almost 4 lakh rows.
wat is optimum soln to export the tables.

Re: Exporting two tables [message #334645 is a reply to message #334644] Thu, 17 July 2008 09:18 Go to previous messageGo to next message
Messages: 25523
Registered: January 2009
Location: SoCal
Senior Member
Please read & follow Posting Guideline as stated above
Re: Exporting two tables [message #334647 is a reply to message #334644] Thu, 17 July 2008 09:26 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
EXPORT and IMPORT would seem to be made for your problem.

If you fancy being a bit techy about the whole thing, you could dump the data out to a file and use an External Table to load it back in again.

You could also look at DBMS_DATAPUMP
Previous Topic: Taking a backup in batches
Next Topic: SQL loader issure with direct='Y'
Goto Forum:

Current Time: Thu Jul 20 19:58:43 CDT 2017

Total time taken to generate the page: 0.23249 seconds