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

PLW-05005: function string returns without value at line string

1 Answers  


ORA-29657: class defined in EXTERNAL NAME clause is used in another subtype

1 Answers  


IMG-00603: unable to access source image data

1 Answers  


ORA-25118: invalid DUMP DATAFILE/TEMPFILE option

1 Answers  


ORA-19331: Last argument to CREATE_DBURI operator must be a column

1 Answers  


ORA-00348: single-process redo failure. Must abort instance

1 Answers  


ORA-38607: FI minimum and maximum itemset length not between [1, string]

1 Answers  


ORA-06266: NETNTT: bad write length

1 Answers  


ORA-00445: background process "string" did not start after string seconds

1 Answers  


ORA-30435: job_queue_processes must be non-zero in order to refresh summaries

1 Answers  


ORA-30394: source statement identical to the destination statement

1 Answers  


DRG-50919: NEAR operand not a phrase, equivalence or another NEAR expression

1 Answers  


Categories