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

RMAN-08531: channel string: proxy copy string is string in media management catalog

1 Answers  


ORA-06254: NETNTT: cannot share connection to cube

1 Answers  


NNL-00896: Requests refused, modifications disabled: number

1 Answers  


RMAN-06168: no backup pieces with this tag found: string

1 Answers  


ORA-00237: snapshot operation disallowed: controlfile newly created

1 Answers  






SQL*Loader-00953: Error shipping read buffer across 2-task

1 Answers  


ORA-25002: cannot create INSTEAD OF triggers on tables

1 Answers  


ORA-19003: Missing XML root element name

1 Answers  


ORA-29804: missing DATA keyword

1 Answers  


PLS-00496: too few columns in SELECT...INTO statement after bursting record targets

1 Answers  


ORA-19005: Duplicate XMLType LOB storage option

1 Answers  


QSM-01057: no query rewrite for this DML expression

1 Answers  


Categories