RE: Tablespaces

From: David Sharples <dsharples_at_cerebrussolutions.com>
Date: Fri, 2 Jul 2004 10:08:27 +0100
Message-ID: <EA29A3FCC723674293FD6286D3F0513E77CB3D@louis.cerebrus.com>

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

---

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

---

Received on Fri Jul 02 2004 - 04:02:18 CDT