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;