Home » SQL & PL/SQL » SQL & PL/SQL » Rebuild index online, ORA-01031
Rebuild index online, ORA-01031 [message #36684] Wed, 12 December 2001 05:14 Go to next message
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 Go to previous message
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

----------------------------------------------------------------------
Previous Topic: Execute script file with variables
Next Topic: Average of date in days,hours,minutes format
Goto Forum:
  


Current Time: Fri Mar 29 06:36:49 CDT 2024