Mike,
While not necessary, it would be a good idea to precreate the tablespaces.
Else, for a clean import the first time, you would need to ensure that the
directory structure for the datafiles exists, you have the permissions to
create files at the OS level, ensure that files dont already exist
Mike - Yes, you need to create those tablespaces first. If the tablespace
isn't there, import will default to the default tablespace of the username
that is running the import. Select bytes from dba_data_files to find the
tablespace sizes.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL
Full import will rebuild the tablespaces.
browse the export file and you will see the commands inside.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 24, 2002 9:25 PM
To do an import from a full export of a