Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2004
    Location
    Manchester, UK
    Posts
    143

    Unanswered: ORA-01935: missing user or role name

    Hi all,

    I'm trying to change the sys password but I get ORA-01935: missing user or role name error. I have tried single quotes, double quotes, upper case, lower case but to no avail.

    Where am I going wrong?

    Thanks,

    Paula.

  2. #2
    Join Date
    Aug 2004
    Location
    Manchester, UK
    Posts
    143
    Forget it, it's no quotes at all apparently!!

    Thanks anyway.

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    for those that need the syntax, logon as sys (or a dba account) and...

    alter user sys identified by password;

    or

    password sys
    (answer the questions, only available in 9i and above)
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •