How to Resolve ORA-02000: missing DATAFILES keyword

ORA-02000

There could be many types of error patterns to throw ORA-02000.

Missing DATAFILES

Tried to drop a pluggable database PDB completely from the container, but it failed with ORA-02000.

SQL> drop pluggable database ERPAPP2 including datafile;
drop pluggable database ERPAPP2 including datafile
                                           *
ERROR at line 1:
ORA-02000: missing DATAFILES keyword

We forgot to pluralize the last keyword, it should be DATAFILES.

Similarly, we may accidentally split the keyword.

SQL> drop pluggable database ERPAPP2 including data files;
drop pluggable database ERPAPP2 including data files
                                           *
ERROR at line 1:
ORA-02000: missing DATAFILES keyword

DATAFILES is a one-word keyword, not a noun phrase.

SQL> drop pluggable database ERPAPP2 including datafiles;

Pluggable database dropped.