When copying a database, what are the best practices?
- I typically, perform a full export from db A, create db B, import
dump from A into B.
- Same as 1, but precreate tables with indexfile and then import
ignore=y.
- Same as 1, but precreate tables with dynamic sql (create table emp
as select * from emp_at_dblink where 1=2), then import ignore=y.
- Copy datafiles, recreate controlfile and rename db.
I am looking to precreate the objects before importing the data and in
the past, I have used #2, but #3 is more flexible and requires no
editing of indexfile.
Are they any disadvantages of using #3 from #2?
Thanks,
Gene
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at
http://www.freelists.org/archives/oracle-l/
FAQ is at
http://www.freelists.org/help/fom-serve/cache/1.html
Received on Wed Feb 18 2004 - 14:05:02 CST