1
  • 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

    SRDBA5 pointsBadges:
  • 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...

    Maitreya5 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following