Moving tables from one schema to another

[CatPlus]

Hello

I have two Oracle databases, both in version 9i... one which we have discontinued to use and the one which is current. These databases were designed by different vendors.

There are tables with data that contain transactions. I want to create the tables and import data from the old database to the new database. I also have access to TOAD

Is there a command line prompt that will install the tables and import data?

Thanks for your guidance

 

[Thargy]

Catplus,

investigate the use of the sql plus copy command - it's designed for precisely such situations.

http://www.oracleutilities.com/SQLPLus/copy.html

will give you chapter and verse on this. TOAD is superb, but not the right tool for this job I suspect.

Regards

Tharg

Grinding away at things Oracular

 

[CatPlus]

Thank you thargtheslayer!

Have a wonderful weekend!

 

[Thargy]

Thanks for the courtesy.

I assume you're burning the midnight oil...

T

Grinding away at things Oracular