Exporting two tables [message #334644] |
Thu, 17 July 2008 09:16  |
ravi214u
Messages: 153 Registered: February 2008 Location: CANADA
|
Senior Member |
|
|
hi,
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.
thanks
|
|
|
|
Re: Exporting two tables [message #334647 is a reply to message #334644] |
Thu, 17 July 2008 09:26  |
JRowbottom
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
|
|
|