The oracle Database prompts ORA-01129 Error

The oracle Database prompts ORA-01129 Error

Database Version

The Code is as follows:
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

Error Reporting ORA-01129

The Code is as follows:
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

The Code is as follows:
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, it is proved that all related tablespaces exist. Further Check the SQL statement and find that the SERVICE is incorrectly written as SERIVCE AND THE SERIVCE user is checked.

The Code is as follows:
SQL> select count (*) from dba_users where username = 'serivce '; COUNT (*) ---------- 0

Through analysis, we can know that the index corresponding to the user does not exist, and thus the ORA-01129 error, according to the principle should report ORA-01918, rather than ORA-01129. querying MOS found Bug 17058847 Creating index in non existing schema results in ORA-1129 and not ORA-1918