Re: Oracle Import and Export Strategy
Date: Thu, 7 Feb 2008 02:59:52 -0800 (PST)
On 7 Feb, 05:24, shantanu <shantanuse..._at_gmail.com> wrote:
> I have a senario of Oracle 8i Database migration, where an existing
> database need to be migrated to a new version with some additional
> tables, schema changes and new indexes and triggers. There are two
> ways in which the export import can be implemented first is a FULL DB
> Imp/Exp and second is TABLE wise. Kindly help me to choose a strategy.
> Will give you more information based on the discussion.
I would go for a full database export. Table by table is too manual a process and so more prone to user error.
HTH -g Received on Thu Feb 07 2008 - 04:59:52 CST