Copying Tables, How ??? [message #373414] |
Mon, 16 April 2001 09:13 |
Akif Rehmani
Messages: 3 Registered: April 2001
|
Junior Member |
|
|
Is there any other way to copy a table rather than
import & Export.
Also help me with the format of Import & export table.
|
|
|
Re: Copying Tables, How ??? [message #373418 is a reply to message #373414] |
Mon, 16 April 2001 10:04 |
Siddharth Bahri
Messages: 18 Registered: March 2001
|
Junior Member |
|
|
Hi Akif,
To copy tables from one oracle database to another import and export is the best way as far as I know.
Other alternatives are
-use SQL Server's Import and Export (or DTS) Wizard
-Use an SQL query like Insert Into table1 select from table2
-Third is to use copy from statement like this
Copy from user1/pwd@db1 to user2/pwd@db2 create using select * from table1
All these require you to be connected to both the databases simultaneously. If you are not connected to both the databases use import/export
If you just want to copy data you can use sql loader utility to export data into a text file and then load into the other table
For import/export just type imp (or exp) on the command prompt and follow the instructions.
rgds.
Siddharth
|
|
|