Re: Importing from Oracle 7.3 to Oracle 8i

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 - 15:57:05 CDT