A summary of the error ORA-01654 of the underlying DBMS

Source: Internet
Author: User

Recently do something about the spatial database, because just get started with a variety of unfamiliar, encountered a lot of problems.

problem: make a query after connecting the spatial database, and suddenly error the underlying DBMS errors [ORA-01654: Index SDE. SDE_LOGFILE_DATA_IDX2 cannot extend ORA-06512 through 1024 (in Tablespace Sde_tbs): in Line1][sys. Oneday]

Reason:

There are two reasons for the error: 1. tablespace size is not enough 2. Insufficient Index Table space

Workaround:

1. Increase the data file for the corresponding Tablespace 2. If the index table space is insufficient, you can rebuild rebuild the index

Here's how:

1. Increase DataFile
ALTER tablespace hrerpdata ADD datafile ' file name ' SIZE 100M
2, increase the size of the datafile belonging to the TABLSAPCE
ALTER DATABASE datafile ' file name ' RESIZE <1000000>m

3. Extended DataFile

ALTER tablespace xxx ADD datafile xxx autoextend on NEXT 500M;
4, you can also reduce the value of next extent or pct_increase
5, the other can reduce debris, or tidy coalesce this tablespace.

Summarize:

By 1, increase datafile 2, increase the size of the TABLSAPCE datafile to solve this problem, the 1, 2 tablespace and ' file name ' replace their own table name can be

Note:

Causes and solutions are transferred from http://blog.csdn.net/langcai1981/article/details/4369878

Tested and feasible

A summary of the error ORA-01654 of the underlying DBMS

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.