Oracle / PLSQL: 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;
Advertisements