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-16187: LOG_ARCHIVE_CONFIG contains duplicate, conflicting or invalid attributes

1 Answers  


ORA-16213: ddl encountered, stopping apply engine

1 Answers  


ORA-22801: invalid object row variable

1 Answers  


ORA-23539: table "string"."string" currently being redefined

1 Answers  


ORA-02180: invalid option for CREATE TABLESPACE

1 Answers   IBM,






RMAN-06708: short write while writing file "string". Wrote string bytes instead of string bytes

1 Answers  


ORA-19400: System type conflict with object SYS.string

1 Answers  


ORA-02728: osnfop: access error on oracle executable

1 Answers  


ORA-14272: only a partition with higher bound can be reused

1 Answers  


ORA-01224: group number in header string does not match GROUP string

1 Answers  


ORA-28002: the password will expire within string days

1 Answers  


LPX-00254: invalid XML declaration

1 Answers  


Categories