export table to another database

[evergreean43]

Is there a way for my Oracle 9i to export a table to another Oracle SID using sql plus?

I tried my client OEM after right clicking on the table name going to Data Management then to export but it says I can not connect to OMS.

Please advise if I can do it with SQL Plus?

 

[Thargy]

evergreen,

you can't export a table with sql plus, because the export utility is server side only.

However, if you want to copy a table from one database to another, then sql plus has the copy command for precisely such a purpose.

copy from scott/tiger@db1
     to scott/db2
     create new_emp 
     using select * from emp;

See SQL*Plus User's Guide and Reference
Release 9.2
Part Number A90842-01 for further details.

Regards

Tharg

Grinding away at things Oracular

 

[evergreean43]

Thanks,


I assume scott/tiger@db1 is schema/password ???

 

[Beilstwh]

Not true, every workstation that has the oracle client installed also has the oracle export and import application installed. look for imp.exe and exp.exe they will be in the BIN directory under the oracle home.

Bill
Oracle DBA/Developer
New York State, USA

 

[LKBrwnDBA]

I tried my client OEM after right clicking on the table name going to Data Management then to export but it says I can not connect to OMS.

Some OEM functions require you have OMS running on some server. -- but you can still use the import/export utilities by executing them manually within a command window.





----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[Thargy]

Beilstwh,

thanks for the information. I've just tried imp and exp client side and they work just fine.

I don't know how I came to think that they'd only work server side.

Regards

Tharg

Grinding away at things Oracular