Home » SQL & PL/SQL » SQL & PL/SQL » Moving data from one tablespace to other
Moving data from one tablespace to other [message #261689] Thu, 23 August 2007 06:11 Go to next message
gauravsunil
Messages: 68
Registered: August 2007
Location: bhubaneswar
Member
Hi friends,
I m very new to oracle.
I have to transfer all indexes from one tablespace to other.
kindly help me with query.
Regards
Sunil Gaurav
Re: Moving data from one tablespace to other [message #261695 is a reply to message #261689] Thu, 23 August 2007 06:28 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
ALTER INDEX your_index REBUILD TABLESPACE yourtablespace;

MHE
Re: Moving data from one tablespace to other [message #261716 is a reply to message #261695] Thu, 23 August 2007 07:16 Go to previous message
gauravsunil
Messages: 68
Registered: August 2007
Location: bhubaneswar
Member
Thanks alot for fast reply Maahir!
Regards
Sunil
Previous Topic: Reset Value
Next Topic: [SOLVED] Little help with concat_all
Goto Forum:
  


Current Time: Thu Dec 08 12:47:08 CST 2016

Total time taken to generate the page: 0.09460 seconds