Printable View
I keep getting the following error.
ERROR at line 1:
ORA-00947: not enough values
Here is the analyze statement:
analyze table louise.prod_support list chained rows
I have run the same analyze statement in other instances without any errors. Any suggestions?
Did you run the script to create the CHAINED_ROWS table in this instance?
MH
I think this may help;
The CHAINED_ROWS table differs from version 8-8i as you can see. You may need to run the 8i script or vice versa, got it?
SQL> desc chained_rows;
Name Null? Type
------------------------------- -------- ----
OWNER_NAME VARCHAR2(30)
TABLE_NAME VARCHAR2(30)
CLUSTER_NAME VARCHAR2(30)
PARTITION_NAME VARCHAR2(30)
HEAD_ROWID UNDEFINED
ANALYZE_TIMESTAMP DATE
SQL> @name
VERSION DB Name LOG_MODE Hostname CREATED
----------------- -------- ------------ ------------ -------------------
8.0.4.4.0
JServer Release 8.1.7.0.0 - 64bit Production
SQL> desc chained_rows;
Name Null? Type
----------------------------------------- --------
OWNER_NAME VARCHAR2(30)
TABLE_NAME VARCHAR2(30)
CLUSTER_NAME VARCHAR2(30)
PARTITION_NAME VARCHAR2(30)
SUBPARTITION_NAME VARCHAR2(30)
HEAD_ROWID ROWID
ANALYZE_TIMESTAMP DATE
The error means:
"You will need to put carraige returns in the script if 2500 characters is exceeded in a single line in the SQL*Plus command line mode."