ORA-39315: Cannot drop the first data file from a permanent

曾春华

ORA-39315: Cannot drop the first data filefrom a permanent or undo tablespace.

Cause: DBMS_METADATA_DIFF wascomparing two permanent or undo

tablespaces. The first data file in the first tablespaceis missing from the second

tablespace. There is no SQL ALTER statement to drop thefirst data file from a

permanent or undo tablespace.

Action: The difference cannot beeliminated with an SQL ALTER statement.