Re: Oracle Import and Export Strategy

On Feb 7, 3:59 pm, gazzag <gar..._at_jamms.org> wrote:
> 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

Hi Thanks for the reply
The data is in tera bytes also the new version of database will have some new tables and schema changes in few existing tables. Also new indexes has to be created for the tables also. So will the FULL DB import satusfies the requirement. Kindly assist regards
shantanu Received on Fri Feb 08 2008 - 00:07:57 CST