The instance was started with DML_LOCKS = 0, and the statement being executed needs a full-table lock (S, X, or SSX).
Restart the instance with DML_LOCKS not equal to zero, and reexecute the statement.
Browse all solutions to database errors from Oracle, MS SQL or MySQL
Try the following links for this error:
http://docs.oracle.com/cd/E16655_01/server.121/e26079/e0.htm
https://community.oracle.com/message/3847752
https://community.oracle.com/message/9316784
https://community.oracle.com/message/9446075
https://community.oracle.com/message/2025568
https://community.oracle.com/message/4497062
https://community.oracle.com/message/1117811
https://community.oracle.com/message/1228927