Database Administration (MOSC)

MOSC Banner

ORA-01723 when GATHER_TABLE_STATS

edited Jan 20, 2010 1:26AM in Database Administration (MOSC) 9 commentsAnswered
 Hi folks,
I am doing a DBMS_STATS.GATHER_TABLE_STATS on a table and it returns immediately with the error ORA-01723: zero-length columns are not allowed. Here is the snippet:

SQL> exec DBMS_STATS.GATHER_TABLE_STATS('HUGO', 'MY_MESSAGE');
BEGIN DBMS_STATS.GATHER_TABLE_STATS('HUGO', 'MY_MESSAGE'); END;
*
ERROR at line 1:
ORA-01723: zero-length columns are not allowed
ORA-06512: at "SYS.DBMS_STATS", line 13437
ORA-06512: at "SYS.DBMS_STATS", line 13457
ORA-06512: at line 1

SQL> desc HUGO.MY_MESSAGE
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 NID                                       NOT NULL NUMBER(20)
 NART                                               CHAR(4)
 DATUM                                              DATE
 STATUS                                             VARCHAR2(3)
 PARTNER                                            VARCHAR2(5)
 SENDE_ANZ                                          NUMBER(5)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center