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: 25574
Registered: January 2009
Location: SoCal
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: EXECUTE IMMEDIATE HELP
Next Topic: How make the complete schema public synonym.....
Goto Forum:
  


Current Time: Mon Aug 21 03:17:31 CDT 2017

Total time taken to generate the page: 0.02190 seconds