|
Hello,
We are facing a strange problem on our database. When the application try to do an insert on some tables (
TABLE1 for example)
, it's encounter ORA-01654 however more than 300Gb is available.
-
The tablespace concerned is DATA , it's defined like :
CREATE
SMALLFILE
TABLESPACE
"DATA"
DATAFILE
NOLOGGING
EXTENT
MANAGEMENT
LOCAL
SEGMENT
SPACE
MANAGEMENT
AUTO
The tablespace contain 28 datafiles like :
'+DATA/Mydb/datafile/data.295.798113921'
SIZE
32000M
REUSE
AUTOEXTEND
ON
NEXT
1024K
MAXSIZE
32000M
SQL> insert into
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at " TABLE1", line 233
ORA-06512: at "TABLE1", line 159
ORA-01654: unable to extend index TABLE1_PK by 128 in tablespace
|
1. Select a discussion category from the picklist.
2. Enter a title that clearly identifies the subject of your question.
3. In the body, insert detailed information, including Oracle product and version.
Please abide by the
Oracle Community guidelines
and refrain from posting any customer or personally identifiable information (PI/CI).
Cloud / Fusion customers - Our Cloud community has moved! Please go to
Cloud Customer Connect
.
