linux表空间满了,如果INDEX表空间满了，数据是否可以插入

SQL> create tablespace test3 datafile '/oradata11/hr9dba/test03.dbf' size 100m;

create tablespace test4 datafile '/oradata11/hr9dba/test04.dbf' size 2m;

Tablespace created.

Tablespace created.

SQL> create table t10 tablespace test3 as select * from all_objects where 1=0;

Table created.

SQL> desc t10

Name                                      Null?    Type

----------------------------------------- -------- ----------------------------

OWNER                                     NOT NULL VARCHAR2(30)

OBJECT_NAME                               NOT NULL VARCHAR2(30)

SUBOBJECT_NAME                                     VARCHAR2(30)

OBJECT_ID                                 NOT NULL NUMBER

DATA_OBJECT_ID                                     NUMBER

OBJECT_TYPE                                        VARCHAR2(19 CHAR)

CREATED                                   NOT NULL DATE

LAST_DDL_TIME                             NOT NULL DATE

TIMESTAMP                                          VARCHAR2(19 CHAR)

STATUS                                             VARCHAR2(7 CHAR)

TEMPORARY                                          VARCHAR2(1 CHAR)

GENERATED                                          VARCHAR2(1 CHAR)

SECONDARY                                          VARCHAR2(1 CHAR)

SQL> create index i_t10  on t10(object_id) tablespace test4

2  ;

Index created.

SQL> insert into t10 select * from all_objects;

insert into t10 select * from all_objects

*

ERROR at line 1:

ORA-01654: unable to extend index SYS.I_T10 by 128 in tablespace TEST4

SQL> select count(*) from t10;

COUNT(*)

----------

0