ora-947 during analyze table for chained records
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ora-947 during analyze table for chained records

  1. #1
    Join Date
    Nov 2001
    Location
    denver
    Posts
    11

    Angry

    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?

  2. #2
    Join Date
    Jan 2001
    Posts
    3,131

    Question

    Did you run the script to create the CHAINED_ROWS table in this instance?

    MH
    I remember when this place was cool.

  3. #3
    Join Date
    Jan 2001
    Posts
    3,131
    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
    I remember when this place was cool.

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width