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

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