Oracle Database hints ORA-01129 Error Resolution

Database version

The code is as follows	Copy Code
Sql> select * from V$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition release 11.2.0.4.0-64bit Production Pl/sql Release 11.2.0.4.0-production CORE 11.2.0.4.0 Production TNS for Hpux:version 11.2.0.4.0-production Nlsrtl Version 11.2.0.4.0-production

Report ORA-01129 Error

The code is as follows	Copy Code
Sql> CREATE index Serivce.ind_xifenfei on Service.t_user (create_date); Create INDEX Serivce.ind_xifenfei on Service.t_user (create_date) * ERROR at line 1: Ora-01129:user ' s default or temporary tablespace does not exist

Query table Space Information

code is as follows	copy code
sql> Select Tablespace_name,contents,status from Dba_tablespaces where Tablespace_name in (' SERVICE ', ' TEMP ');   tablespace_name                 contents  STATUS ------------------------------------------------ service                          Permanent ONLINE temp                            Temporary ONLINE

Through analysis, prove that the relevant table space exists, further check the SQL statements, found that the service was incorrectly written for serivce, check serivce users.

The code is as follows	Copy Code
Sql> Select COUNT (*) from dba_users where username= ' serivce '; COUNT (*) ---------- 0

Through analysis, you can know that because the index corresponding user does not exist, resulting in a ORA-01129 error, according to the truth should be reported ORA-01918, rather than ORA-01129. Query MoS discovery Bug 17058847 creating index in non Existing schema results in ORA-1129 and not ORA-1918