How to move an index to another tablespace

Category : Home > Databases > Oracle

SQL> alter index [index_name] rebuild tablespace [tablespace_name];

Options


Start discussion or add comment to this tip

Details

Tip reference : #184 views : 1440	Added on : 02/11/08	Submited by : h8dk97

Send a message	Printer friendly output Display this member's tips (185)


<< Previous Next >>

	Most viewed tips
	Databases > Oracle > Security : How to unlock Oracle user account
	Databases > Oracle > Performance Tuning : How to enable trace in Oracle
	Operating Systems > Unix : How to kill Unix user session
	Databases > Oracle : Kill user session

	All categories Databases \| Programming \| Hardware \| Operating Systems \| Networking \| Internet \| ERP / CRM \| Games & Multimedia \| Graphics & Design \| Miscellaneous \| Office Software \| TipLib FAQ