How to move LOB index to another tablespace

Category : Home > Databases > Oracle

SQL> ALTER TABLE SAPSR3.CNVMBTCLU MOVE LOB (CLUSTD) STORE AS (TABLESPACE PSAPTDMS);

-- where CLUSTD is the lob column

Options


Start discussion or add comment to this tip

Details

Tip reference : #281 views : 742	Added on : 04/21/11	Submited by : h8dk97

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


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 \| Mobile Phones / Tablets \| Office Software