Re: Moving instance to another host

Carlos A. Gonzalez wrote:
> A) Export the whole database in the old host, create the database and
> corresponding tablespaces in the new host and then do the import.
>
> Advantages: Optimize space usage (Compress parameter)
> Disavantages: Too slow
> B) FTP the data files to the new host, copy the data files to the
> corresponding directories, edit the Control File and startup the > instance.
> Advantages: Faster to do
> Disavantages: No way to optimize the old database.

I vote for B. Fast & simple. Current wisdom says "multiple extents are GOOD for you, when used appropriately". If needed, after B) use A) to small set of important tables/indexes.

• Lassi Salo, Nokia Telecommunications,
• P.O.Box 310, FIN-00045 Nokia Group, FINLAND
• Phone: +358-9-511-22725, Fax: +358-9-511-22227
• lassi.salo@ntc.nokia.com, http://www.nokia.com/