Oracle Error ORA-39316: Cannot resize a data file in a smallfile tablespace.

Oracle Error Message

ORA-39316: Cannot resize a data file in a smallfile tablespace.

Reason for the Error

DBMS_METADATA_DIFF was comparing two smallfile tablespaces. A data file in the first tablespace is of a different size from the corresponding data file in the second tablespace. There is no SQL ALTER statement to resize a data file in a smallfile tablespace.

Solution

The difference cannot be eliminated with an SQL ALTER statement.