Re: Oracle 8i EXP/IMP Question.

Hi.

That's the point of exp/imp - its a means of being able to span Platform (OS), Oracle Version, etc.
You need to pre-create the database prior to importing from the dump file.
The dump file contains the DDL to re-create the tablespaces as they existed at the time of the export.
If you need to alter the parameters of the tablespace creation - you will have to pre-create the tablespaces. If you need to alter the parameters of the objects' creation - you will need to pre-create the user and objects.

Use the parameter SHOW=Y to list the contents of the dump file - as:

<parfile>
userid=system/manager_at_dev
full=Y
file=d:\Oracle\Admin\DEV\exp\dev_dat.dmp log=d:\Oracle\Admin\dev\imp\imp_dev_dat.log SHOW=Y
ROWS=N
DESTROY=N
</parfile>

C:\> imp parfile=d:\Oracle\Admin\dev\imp\imp.par

Export file created by EXPORT:V08.01.07 via conventional path import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
 "CREATE TABLESPACE "RBS" DATAFILE 'D:\ORACLE\ORADATA\DEV\RBS01.DBF' SIZE 52"
 "428800 REUSE AUTOEXTEND ON NEXT 16777216 MAXSIZE 2047M DEFAULT STORAGE(IN"
 "ITIAL 524288 NEXT 524288 MINEXTENTS 8 MAXEXTENTS 4096 PCTINCREASE 0) ONLINE"
 " PERMANENT "
 "CREATE TABLESPACE "USERS" DATAFILE
'E:\ORACLE\ORADATA\DEV\USERS01.DBF' SIZ"  "E 20971520 REUSE AUTOEXTEND ON NEXT 16777216 MAXSIZE 2047M DEFAULT STORAG"
 "E(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 4096 PCTINCREASE 0) ON"
 "LINE PERMANENT " hth,

Paul

"Dr. Mueller" wrote:
>
> Is it possible with the EXP command to backup from a database named "A",
> then IMPort into a database named "B"? Or does the database name have to be
> the same when importing?
>
> Thank you.
Received on Sun Apr 01 2001 - 22:20:46 CDT