ORA-01031 Insufficient privileges
I am trying to generate FK on table in schema A, which is the reference of PK on another table in schema B. The owner of schema A is also a DBA. It gives an error ORA-01031 Insufficient privillages

Answer Question   |  June 16, 2009  6:51 AM
Foreign keys, ORA-01031, Oracle development, Oracle error messages, Oracle foreign keys, Oracle primary keys, Primary keys

oar-01033
ORA-01033 and from I understand from reading posts..i’m to log in as sys/password as sysdba. When I do this, sqlplus is returning the error message: ORA -01031 Insufficient privileges. I’ve tried several different usernames…but SYS should work as i’ve used this many many times in the past “as sysdba”. Does anyone know what to do [...]

Answer Question   |  April 21, 2008  8:21 AM
ORA-01031, ORA-01033, Oracle error messages, SQLPlus