Re: Importing from Oracle 7.3 to Oracle 8i

Also 8.1.5 needs a lot more space in the System tablespace than what you're used to. Add another 200M datafile to what you have now.

Van

Jeff Hunter <jeffh_at_btitelecom.net> wrote in message news:37f27d67_at_defiant.btitelecom.net...
> Sure, that would be no problem. It might be slow because you have to
> pre-create your indexes, but otherwise is pretty straight forward:
> 1. export database from 7.3
> % exp system/manager file=exp.dmp full=y log=exp.log
>
> 2. import on new database with indexfile parameter
> % imp system/manager file=exp.dmp indexfile=create_structures.sql full=y
>
> 3. edit storage parameters in index file
> % vi create_structures.sql
> (take out things like ^REM, etc to get your ddl)
> (edit your storage parameters)
>
> 4. Create users in new database
>
> 5. Create structures in new database
> % sqlplus system/manager @create_structures.sql
>
> 6. import data with ignore=y option
> % imp system/manager file=exp.dmp full=y ignore=y commit=y log=imp.log
>
>
> Other things to consider as long as you are doing a full export/import:
> 1. Using partitioned tables/indexes
> 2. Modifying your db_block_size
>
> mohotta_at_my-deja.com wrote in message <7strgf$k60$1_at_nnrp1.deja.com>...
> >We want to export our current Oracle 7.3 database, recreate the objects
> >in another server running Oracle 8i, and import the data into the 8i
> >server.
> >
> >To better tune my database, I want to change the initial extent, pctfree
> >and pctused settings for various tables. Would that prevent me from
> >successfully importing the data? How identical does the new database
> >have to be to the old?
> >
> >Alton Chinn
> >San Francisco Planning Dept
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Before you buy.
>
>
Received on Wed Sep 29 1999 - 19:55:33 CDT