Oracle: ORA-01916 Error Message

ORA-01916 Error Message

Learn the cause and how to resolve the ORA-01916 error message in Oracle.

Description

When you encounter an ORA-01916 error, the following error message will appear:

• ORA-01916: keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND or END/DROP expected

Cause

You tried to execute an operation that required either the ONLINE or OFFLINE keyword.

Resolution

The option(s) to resolve this Oracle error are:

Option #1

Insert the missing keyword and re-execute the operation.

For example:

ALTER DATABASE
 DATAFILE 'disk1:db_file1.dat' RESIZE 20 M;