Help - Search - Members - Calendar
Full Version: copy data from one database to another
Oracle DBA Forums > Oracle > Oracle Forum
Hi All,
There is a script written to copy schemas from one database to another database, in which the following parameters are defined

source_schema Source schema/account/user name
source_password Source schema password
source_database Source schema TNS alias

The schema the office data would be copied to
target_schema Target schema/account/user name
target_password Target schema password
target_database Target schema TNS alias

I have thought of steps to follow. I need help from you all to tell me if the steps are correct

1> copy the script to some directory on the target database server
2> sqlplus /nolog and then sql>@script.sql

Is this correct?? Or should i follow the same steps on the Source Database
Please help
only you can answer that - its your script and you can read it to see what you need
"Is this correct?? Or should i follow the same steps on the Source Database"

How would we know?

It's your script, you tell us how it works.

Is this homework?
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2016 Invision Power Services, Inc.