Re: Oracle Import and Export Strategy

From: gazzag <>
Date: Thu, 7 Feb 2008 02:59:52 -0800 (PST)
Message-ID: <>

On 7 Feb, 05:24, shantanu <> 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

Original text of this message