Re: Full Import/tablespace sizes

2002-10-24 Thread Rajesh . Rao
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

RE: Full Import/tablespace sizes

2002-10-24 Thread DENNIS WILLIAMS
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

Re: Full Import/tablespace sizes

2002-10-24 Thread Yechiel Adar
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