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
Thanks

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?