Oracle Database hints ORA-01129 Error Resolution

Source: Internet
Author: User
Tags create index oracle database

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.