Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Tablespaces
Easy way, create the tablespace
Then do alter table xxx move tablespace <new_tablespace>
Much much quicker
Can also do the same for indexes
Alter index yyy rebuild tablespace <new tablespace>
-----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.
Regards,
Balu
This mail is scaned by eScan Anti Virus Software
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org