| ora-00604: [message #54774] |
Wed, 04 December 2002 05:33  |
ssa
Messages: 8
Registered: November 2002
|
Junior Member |
|
|
hi
please can any body help me, i am getting error as follows
SQL> start custariff_info_fk.idx
Creating Index CUSTARIFF_INFO_FK on Table CUST_TARIFF_INFO
CREATE INDEX CUSTARIFF_INO_FK ON CUST_TARIFF_INFO
ERROR at line 1:
ora-00604:error occurred at recursive SQL_level 1
ora-01400:cannot insert NULL into ("SYS"."IND$"."INDMETHOD#")
thanks u
dba guru
|
|
|
|
| Re: ora-00604: [message #54967 is a reply to message #54774] |
Fri, 20 December 2002 10:53  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
Review your create index DDL statement. For some reason this sql is trying to insert NULL value in INDMETHOD# column of IND$ table. This column takes NOT NULL values only, eg
SQL> desc sys.ind$
Name Null? Type
----------------------------------------- -------- -----------------
OBJ# NOT NULL NUMBER
DATAOBJ# NUMBER
TS# NOT NULL NUMBER
FILE# NOT NULL NUMBER
BLOCK# NOT NULL NUMBER
BO# NOT NULL NUMBER
INDMETHOD# NOT NULL NUMBER
COLS NOT NULL NUMBER
PCTFREE$ NOT NULL NUMBER
INITRANS NOT NULL NUMBER
MAXTRANS NOT NULL NUMBER
PCTTHRES$ NUMBER
TYPE# NOT NULL NUMBER
FLAGS NOT NULL NUMBER
PROPERTY NOT NULL NUMBER
BLEVEL NUMBER
LEAFCNT NUMBER
DISTKEY NUMBER
LBLKKEY NUMBER
DBLKKEY NUMBER
CLUFAC NUMBER
ANALYZETIME DATE
SAMPLESIZE NUMBER
ROWCNT NUMBER
INTCOLS NOT NULL NUMBER
DEGREE NUMBER
INSTANCES NUMBER
TRUNCCNT NUMBER
SPARE1 NUMBER
SPARE2 NUMBER
SPARE3 NUMBER
SPARE4 VARCHAR2(1000)
SPARE5 VARCHAR2(1000)
SPARE6 DATE
Or post your indes DDL for review. May be we can see where is the error.
Hope that helps,
clio_usa
OCP - DBA
dbaclick.com
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
