|
1 2 3 4 |
INSERT INTO SIEBEL.S_EVT_ACT ( * ERROR at line 1: ORA-01950: no privileges on tablespace 'SIEBEL_INDEX25AS' |
|
1 2 3 4 |
SQL> select owner,table_name,tablespace_name,cluster_name,iot_name from dba_tables where table_name='S_EVT_ACT'; OWNER TABLE_NAME TABLESPACE_NAME CLUSTER_NAME IOT_NAME ------------------------------ ------------------------------ SIEBEL S_EVT_ACT SIEBEL_500 |
|
1 2 3 4 5 6 7 |
SQL> select owner,table_owner,table_name,index_name,index_type,tablespace_name from dba_indexes where table_name='S_EVT_ACT'; OWNER TABLE_OWNER TABLE_NAME INDEX_NAME INDEX_TYPE TABLESPACE_NAME --------------------------------------------------------------- SIEBEL SIEBEL S_EVT_ACT S_EVT_ACT_F11 NORMAL SIEBEL_INDEX25AS JIM SIEBEL S_EVT_ACT S_EVT_ACT_M6 FUNCTION-BASED NORMAL SIEBEL_INDEX25AS JIM SIEBEL S_EVT_ACT S_EVT_ACT_M8 FUNCTION-BASED NORMAL SIEBEL_INDEX25AS SIEBEL SIEBEL S_EVT_ACT S_EVT_ACT_F14 NORMAL SIEBEL_INDEX25AS |
