Re: AW: Interview Question

From: Suhen Pather <PatherS5_at_telkom.co.za>
Date: Wed, 27 Sep 2000 10:07:30 +0200
Message-Id: <10632.117962@fatcity.com>

Import does create the tablespace for you only if the directory structure = is the same for both databases (which I doubt). If however you are trying to recreate a database

-   full export=20
-   remove database
-   full import

Then the file system structures would be the same so you may not have to = recreate the tablespaces.

Oracle tries to create the database as it existed before, using the same = datafile paths/names.
If the path does not exist or you do not have access or space it would = fail. =20
So as a rule of thumb I think it is best to precreate the tablespace = before import.

HTH
Suhen

>>> ivo.libal_at_knapp-systems.com 09/27/00 10:27AM >>> Except system - which is created during create database - you dont have to create tablespaces - they are created
Ivo Libal

hired or fired?

> -----Urspr=FCngliche Nachricht-----
> Von: Sandeep Kurliye [SMTP:Sandeep.Kurliye_at_almarai.com]=20
> Gesendet am: Mittwoch, 27. September 2000 08:26
> An: Multiple recipients of list ORACLE-L
> Betreff: Interview Question

>=20

> Hi All,

>=20

> Here is one interview question.

>=20
> You have taken full export and now importing to new database. Do I have =
to
> create the same tablespaces (which I was having in original database)
> before
> importing or full import will take care of it???

>=20

> TIA,

>=20

> Sandeep.

>=20

> --=20
> Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
> --=20
> Author: Sandeep Kurliye
> INET: Sandeep.Kurliye_at_almarai.com=20

>=20


> 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=20
--
Author: Libal, Ivo
  INET: ivo.libal_at_knapp-systems.com=20

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

Received on Wed Sep 27 2000 - 03:07:30 CDT