RE: Tablespaces
- From: "David Sharples" <dsharples@xxxxxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 2 Jul 2004 10:08:27 +0100
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
