GRANT CREATE VIEW TO <dbusername>; Note: run above command after log in as admin. for admin login: 'connect sys/sys sysdba'