How to fix the Oracle error ORA-19721: Cannot find datafile with absolute file number string in tablespace string?

In this post, you’ll learn more about the Oracle ErrorORA-19721: Cannot find datafile with absolute file number string in tablespace string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-19721: Cannot find datafile with absolute file number string in tablespace string

Reason for the Error ORA-19721: Cannot find datafile with absolute file number string in tablespace string

Can not find one of the datafile that should be in the Pluggable Set.

How to fix the Error ORA-19721: Cannot find datafile with absolute file number string in tablespace string ?

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

Make sure all datafiles are specified via import command line option or parameter files.