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.