RE: Tablespaces

I have not tested this in several versions, but in the past, as long as the tablespace specified in the export did not exist or was not allowed for the user during the import session, you could get it to try the default tablespace for the user. I can't remember whether it's a flag or the default behavior.

If that doesn't work any more, it shouldn't be much work to export each user no rows and disect/convert the tablespace names with your favorite tool.

-----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
-----------------------------------------------------------------


----------------------------------------------------------------
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
-----------------------------------------------------------------