Re: Import questions

If you want the objects to end up in the same tablespaces, then the names must be exactly the same (otherwise the default tablespace is used).

If the filesystem and layout on box x is the same as box y then the full import will create the tablespaces using the datafile specs. in the dump file.

If the filesystem is different then you should pre-create the tablespaces you need before doing the import. It is probably best to do this anyway (even if the filesystem matches) as you can be sure that the datafiles are where you want them to be and there will be no surprises like running out of disk space. When you do this the import will not try to create the tablespaces, since ones with the same name already exist.

• Bill.

At 11:40 08/11/01 -0800, you wrote:
>Hi
>Is it necessary to create exactly same tablespace name when I want to FULL
>import of database structure?
>Let i have one instance A on x box.
>I have created one instance A on Y box
>I want to full import structore of database on box Y.
>Thanks
>Seema
>
>
>_________________________________________________________________
>Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Seema Singh
> INET: oracledbam_at_hotmail.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Buchan
  INET: wbuchan_at_uk.intasys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).