Re: Oracle Import and Export Strategy

On Feb 8, 3:59 pm, Cristian Cudizio <cristian.cudi..._at_yahoo.it> wrote:
> 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
> > regards
> >shantanu
>
> 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?
>
> Regards
>  Cristian Cudizio
>
> http://oracledb.wordpress.comhttp://cristiancudizio.wordpress.com- Hide quoted text -
>
> - Show quoted text -

Hi
 Sorry for the communication gap , actually the senario is to migrate the database in same version ie oracle 8i to oracle 8i . The new backup will include new tables, schema changes , new indexes and triggers. So shall i go for a FULL mode or TABLE mode. Regards
Shantanu Received on Sun Feb 10 2008 - 23:27:05 CST