Re: [Q] How to duplicat all data from one DB to another DB

We have two data base one is live data base and anothe is training DB. Both DB has same tablespace and tables, but the size is different (live DB size a lot bigger than training DB). We have been insert some data in live DB and training DB still empty. Can someone tell me how to duplicat the data from live DB to training DB? Thank you

Set up database links from your production database to your test database and then you can run a script that works like this:

Insert into table1
cola,
colb,
etc...
select
cola,
colb,
etc...
from table1_at_prod

The _at_prod is your database link that points to the production database table.

Shawn Spiars, Senior DBA
American General Life Insurance Co. Received on Sun Apr 28 1996 - 00:00:00 CEST