Browse oracle-l: This Month's Archive • Main Archive Page • Related posts • Previous by Date • Next by Date

RE: Tablespace

From: "Nahata, Naveen (US - Hyderabad)" <nnahata@xxxxxxxxxxxx>
To: <compute@xxxxxxxxxxxxxxx>, "Oracle Mailing List" <ORACLE-L@xxxxxxxxxxxxx>
Date: Thu, 30 Sep 2004 07:33:47 -0500

Balu,

You can create separate tablespaces for different modules and then
migrate the tables and indexes to the new ones.

To move the tables you can use 'ALTER TABLE .... MOVE TABLESPACE ...'
command and to move indexes you have to rebuild them to the new
tablespace.

Regards
Naveen

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Computer Centre -
NIIPL
Sent: Thursday, September 30, 2004 5:23 PM
To: Oracle Mailing List
Subject: Tablespace

Dear All,

We are having one user tablespace which contains all our data (Accounts,
Payroll, Sales,Materials etc). We would like to create separate data
tablespace and index tablespace for the different modules.
E.g.:- Accounts data tablespace, Accounts Index Tablespace.

Please guide us to achieve the same.

Thanks and Regards,
Balu.
This mail is scaned by eScan Anti Virus Software




--
http://www.freelists.org/webpage/oracle-l




This message (including any attachments) contains confidential =
information intended for a specific individual and purpose, and is =
protected by law.  If you are not the intended recipient, you should =
delete this message.  Any disclosure, copying, or distribution of this =
message, or the taking of any action based on it, is strictly =
prohibited.
--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

RE: Tablespace
From: Michael Fontana

RE: Tablespace

Other related posts: