How to fix the Oracle error ORA-03222: average row size and row count must be greater than zero?

In this post, you’ll learn more about the Oracle ErrorORA-03222: average row size and row count must be greater than zero with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

Reason for the Error ORA-03222: average row size and row count must be greater than zero

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

How to fix the Error ORA-03222: average row size and row count must be greater than zero ?

You can fix this error in Oracle by following the below steps

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.