How to Resolve ORA-02000: missing keyword

  • by

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 word, 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.

Leave a Reply

Your email address will not be published. Required fields are marked *