Re: Oracle Import and Export Strategy
Date: Fri, 8 Feb 2008 02:59:07 -0800 (PST)
On Feb 8, 7:07 am, shantanu <shantanuse..._at_gmail.com> wrote:
> 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
You don't speak about which is the new version of the database. If it
is 10g as per metalink note 132904.1
it seems that full mode is not supported. What about SCHEMA/USER mode?