How to resolve ORA-01916 Error Message in Oracle database

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

Description

When you come upon 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 both the ONLINE or OFFLINE keyword.

Resolution

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

Option #1

Insert the missing key-word and re-execute the operation.

For example:

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