RE: Tablespaces

Even though the exp file create table statement references a tablespace as long as that tablespace does not exist in the imp target the user default tablespace will be used to create the object. If the tablespace exists in the imp target then I believe if you set the owner to having zero quota on the referenced tablespace that the create will default. Unfortunately, I do not have a test system available to me right now where I can test this last statement. But the first point I reply on all the time.

HTH -- Mark D Powell --

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Wit Serdakovskij Sent: Friday, July 02, 2004 11:44 AM
To: oracle-l_at_freelists.org
Subject: Re: Tablespaces

Hello, Ganesh.Raja,

> Create the Users and assign them Default Tablespace and then Import the
> Tables into them. When the Tables are imported they will be Imported into
> the Default Tablespace.
>
> Better Still u can Move the Tables from One Tablespace to the Other and
> Rebuild the Indexes.

It's not true at all. The export file contains TABLESPACE clause of CREATE TABLE statement.

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Computer Centre - NIIPL
> Sent: 02 July 2004 09:41
> To: Oracle Mailing List
> Subject: Tablespaces
>
>
> Dear All,
>
> In our test database we are having one tablespace. The tablespace contains
> all the tables for different users. ( 1200 Tables). We would like to have
a
> separate tablespace for each user in the real time database.If we use the
> exp/imp utility, the table will be created in same tablespace as of the
> original one. Is there any way to insert the tables in to the newly
created
> tablespaces while using imp utility.
>
> Please help us.

1. Get the list of statements for creation of all the tables (with tablespace needed).
2. exp
3. imp ignore=y

--
wbr,
Wit.

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------