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