Re: Oracle Import and Export Strategy

On 7 Feb, 05:24, shantanu <shantanuse..._at_gmail.com> wrote:
> Hi
> 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.
>
> regards
> Shantanu

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