Home » SQL & PL/SQL » SQL & PL/SQL » Separate Index and tables in two different tablespace
Separate Index and tables in two different tablespace [message #582160] Sun, 14 April 2013 18:19 Go to next message
janak_patel85@yahoo.com
Messages: 4
Registered: October 2012
Location: Ahmedabad
Junior Member

Hello Friends,

How to saperate inndexes and tables in two different tablespcae.......???
Re: Separate Index and tables in two different tablespace [message #582161 is a reply to message #582160] Sun, 14 April 2013 19:16 Go to previous messageGo to next message
BlackSwan
Messages: 21938
Registered: January 2009
Senior Member
>How to saperate inndexes and tables in two different tablespcae.......???
There is no reason to do so.

ALTER INDEX REBUILD TABLESPACE NEW_TABLESPACE;

Re: Separate Index and tables in two different tablespace [message #582666 is a reply to message #582161] Sat, 20 April 2013 23:45 Go to previous message
chaopauljun
Messages: 1
Registered: March 2013
Location: chengdu
Junior Member
1、 TABLE MOVE TABLESPACE

  alter table table_name move tablespace tablespace_name;
2. INDEX MOVE TABLESPACE
alter index index_name rebuild tablespace tablespace_name;
Previous Topic: String sorting
Next Topic: Simple updation failed ? Reason ?
Goto Forum:
  


Current Time: Wed Apr 16 23:58:18 CDT 2014

Total time taken to generate the page: 0.09037 seconds