Oracle Export & Import

Thanx

hi,
when you export a user from one oracle database and then import it into another one, what really happens is that first of all, the export utility extracts the structure of user objects (tables, view, procedures amd so on) and then the data. when you make an import the utility first creates tables using the structure previosuly exported, than insert all data and finally creates other ojects such as triggers or procedures.

because of this, tables will be created on the very same tablespaces and if not available, the utility will fail.

if you want to import into another tablespace you will need to first create all tables and indexes by yourself (with DDL statements) in the desidered tablespaces and the import with the IGNORE=Y parameter: the utility will try to create tables in the original tablespace, this will fail because they alread exists and because of the IGNORE parameter, it will go on inserting data. looking at the import log you will find some errors creating the tables but this will be ok.

hope it needed,
Ing. Gianluca Albera
BASE Solution Engineering

This question was closed by the author

Thanx

Thanx