ORA-01031 Questions and Answers

Recent IT Questions

1 - 2 of 2
<<PREVIOUS 1 NEXT>>

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

View Answer   |  Jun 16 2009  6:51 AM GMT
ORA-01031, Foreign keys, Primary keys
asked by SRDBA

  5 pts.

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...

View Answer   |  Apr 21 2008  8:21 AM GMT
Oracle error messages, SQLPlus, ORA-01031
asked by Maitreya

  5 pts.

1 - 2 of 2
<<PREVIOUS 1 NEXT>>