Oracle Database 11g EE 11.2.0.4.0 64bit on HP-UX
SQL> CREATE INDEX SERIVCE.ind_xifenfei ON SERVICE.t_user(create_date); ORA-01129: user's default or temporary tablespace does not exist
SELECT tablespace_name, contents, status FROM dba_tablespaces
WHERE tablespace_name IN ('SERVICE','TEMP');
-- 兩者皆 ONLINE
SERIVCE vs SERVICE。SELECT COUNT(*) FROM dba_users WHERE username='SERIVCE'; -- 0
索引建立指定的 Schema 不存在,Oracle 應拋 ORA-01918: user does not exist,但因 Bug 17058847 錯誤拋出 ORA-01129,極具誤導性。
修正 Schema 拼寫:CREATE INDEX SERVICE.ind_xifenfei ON SERVICE.t_user(create_date);