ORA-03222: average row size and row count must be greater
than zero



ORA-03222: average row size and row count must be greater than zero..

Answer / guest

Cause: Either a bad value passed to
dbms_space.create_table_cost() or explain plan did not pass
through size information.

Action: Check the row size parameter in
dbms_space.create_table_cost(). For explain plan, make sure
statistics have been computed for all source tables in the
CREATE TABLE AS SELECT statement.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-12163: TNS:connect descriptor is too long

1 Answers  


ORA-36952: (XSFCAST23) You cannot specify a cycle number when querying the string forecasting option.

1 Answers  


ORA-01143: cannot disable media recovery - file string needs media recovery

1 Answers  


RMAN-05504: at least two redo log files or groups must be specified for this command

1 Answers  


PCC-02210: C++ punctuation sequences are not permitted

1 Answers  






ORA-07482: snlmini: cannot create lock manager instance.

1 Answers  


TNS-00017: INTCTL: error while performing NS receive command

1 Answers  


PLS-01410: Use of 'MOD' token

1 Answers  


ORA-12515: TNS:listener could not find a handler for this presentation

1 Answers  


ORA-16076: unknown standby database destination

1 Answers  


LSX-00026: unknown attribute "~S"

1 Answers  


DRG-13311: USER_LEXER stored procedure name contains a semicolon

1 Answers  


Categories