Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Tablespace

RE: Tablespace

From: Nahata, Naveen (US - Hyderabad) <nnahata_at_deloitte.com>
Date: Thu, 30 Sep 2004 07:33:47 -0500
Message-Id: <CC8FBD9B14C11941BF3A19E9F867A59B349F71@uscnt0429.us.deloitte.com>


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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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 Received on Thu Sep 30 2004 - 07:29:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US