> When copying a database, what are the best practices?
>
> 1) I typically, perform a full export from db A, create db B, import
> dump from A into B.
>
Usually
> 2) Same as 1, but precreate tables with indexfile and then import
> ignore=y.
>
If you want to improve table structures, for example move frequently null
value columns to the end, etc.
> 3) 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.
>
I dont't think why this could be better than a export, this will take
hundreds of times more.
> 4) Copy datafiles, recreate controlfile and rename db.
I would prefer 1, that 4 if this have lots of data and performance is
critical, because when you export, there is a optimization.
We always do 4), because is faster, and cleaner, you don't have to be
checking if import was successful, if you don't forget some function
somebody create in sys schema, by mistake, etc.
>
> 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
> -----------------------------------------------------------------
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
-----------------------------------------------------------------
----------------------------------------------------------------
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
-----------------------------------------------------------------
----------------------------------------------------------------
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:53:55 CST
