-
copying large table
What is the fastest way to copy a large table(15 million) records from development into test env.
Thanks.
-
Have u tried sqlplus copy command? Or just exp/imp.
F Melo
-
-
Originally posted by pando
db link + insert append
Plus parallel if possible.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
Or Copy in N sessions if you can logically break up ur Rows in the table .
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
Originally posted by pando
db link + insert append
Use ctas than insert..
SQL> create table ctas nologging as select * from acc_grn_select@dbls;
Table created.
real: 1109
SQL> select count(*) from ctas;
COUNT(*)
---------
74006
real: 203
SQL> truncate table ctas;
Table truncated.
real: 140
SQL> insert into ctas /*+append*/ nologging select * from acc_grn_select@dbls;
74006 rows created.
real: 19828
We used to copy 5 million records with ctas in less than 5 minutes.
-
Wouldnt creating table with a non matching condition 1=2 be better ??
Success Consists of Getting Up Just One More Time Than You've Fallen Down
Be Blessed
-
he needs the table WITH RECORDS
-
> Use ctas than insert..
Perhaps if you specified the /*+ APPEND */ hint and NOLOGGING option correctly you would find INSERT was comparable to CTAS?
Padders
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|