Rebuild index online, ORA-01031 [message #36684] |
Wed, 12 December 2001 05:14 |
Yan Seiler
Messages: 13 Registered: December 2001
|
Junior Member |
|
|
Hi,
I have a problem within PL/SQL when trying to rebuild an index using keyword online:
This one works fine within PL/SQL:
ALTER INDEX LISADMIN.Isample REBUILD TABLESPACE INDX
But this one gives error ORA-01031:
ALTER INDEX LISADMIN.Isample REBUILD ONLINE TABLESPACE INDX
I don't understand as my user has all the system priviledges related to indexes, does someone have an idea ?
Thanks
Yan
----------------------------------------------------------------------
|
|
|
Re: Rebuild index online, ORA-01031 [message #36689 is a reply to message #36684] |
Wed, 12 December 2001 16:03 |
SAlapati
Messages: 12 Registered: November 2001
|
Junior Member |
|
|
Yan, the syntax is
SQL> ALTER INDEX LISADMIN.Isample REBUILD ONLINE ;
If you use ONLINE then you must not mention the Tablespace name
hope this helps,
SAlapati
----------------------------------------------------------------------
|
|
|