Copying data between two schemas

[sureshot]

I have two identical schemas in two databases I need to copy data between them.

Is there any script to export the data from first schema, delete the data from second schema and import first schema's data.

I do this multiple times every day and if someone can suggest a script, it would save my life...

[stecal]

UNIX? What an excellent learning opportunity you have to learn a bit of shell scripting. Look at UNIX Made Easy. You can look online for Livefire Labs. Learn how to fish.

[pando]

Originally posted by stecal
UNIX? What an excellent learning opportunity you have to learn a bit of shell scripting. Look at UNIX Made Easy. You can look online for Livefire Labs. Learn how to fish.

Agree!

If I was you Sureshot I would first read about how export/import works

[julian]

Originally posted by sureshot
I have two identical schemas in two databases I need to copy data between them.

If they are identical why do you need to copy from one to the other :-)

[badrinathn]

Originally posted by stecal
UNIX? What an excellent learning opportunity you have to learn a bit of shell scripting. Look at UNIX Made Easy. You can look online for Livefire Labs. Learn how to fish.

Another oppurtunity to learn the oracle itself...
Go ahead setup the dblink between the two, create a job on the second instance to periodically (whenever you need ) to truncate the tables and pull the data from the first db and populate...

You can bill more though!!

[sudheer_nm]

Try with sql copy command to transfer data between databases

[sureshot]

I expected someone to post a script... Unix/korn shell not a big deal...

If someone knows or already doing this, can you post the script?

Or a metalink note?

[stecal]

Is there any script to export the data from first schema, delete the data from second schema and import first schema's data.

Yes, the one you write.

[slimdave]

Have you considered setting up replication between the databases? It would get around the issue of the script entirely.

[sureshot]

Has anyone used DBMS_RECTFIER_DIFF package? It is used in replication, but it can be used to synchronize two database tables/schemas.

Any help on how to use OEM change manager for this job is appreciated.