What is tablespace?
Oracle database are logically divided into one or more tablespaces. An oracle tablespace is a logical entity that contains the physical datafiles.
Tablespaces are store in all the usable data of the database and the data in the tablespace are stored in one or more datafiles.
Datafiles are Oracle-formatted operating system files. Oracle creates a datafile for a tablespace when you specify the keyword DATAFILE during tablespace creation
Issue Description:
When I tried to rebuild one of the indexes I received the following error:
SQL> alter index I_WRI$_OPTSTAT_H_ST rebuild;
alter index I_WRI$_OPTSTAT_H_ST rebuild
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01502: index 'SYS.I_WRI$_OPTSTAT_IND_OBJ#_ST' or partition of such index is in unusable state.
Looking for Auto Locksmith and Car Key maker services in San Antonio TX. DBA Locksmith Provides Cost Effective Automotive Locksmith, auto key makers, car locksmith Services in San Antonio and surrounding areas. 24/7 Mobile Service (210) 299-5200.