amitavachatterjee1975 wrote:insert into dev_table select * from prod_table;
I have 5 tables in prod DB with lots of data which I need in QA db to test a view. What is the easiest and better way to do that.
amitavachatterjee1975 wrote:I don't recommand to go thru Database link since prod data is critical and Can be accessed only by the authorized people you could use COPY command in sqlplus , you can use exp/imp lot of ways but don't ever connect developer or QA to your PROD directly .
Prod table is ranging from 2 million rows to 8 million rows.
DBLink option sounds better. Where do I create the DBLink in prod or QA.
Version is 10g.