1. Hey Guest Did you know you can win an Honor 10 phone worth ₹33,000 and an additional ₹70,000 in paytm vouchers, just by replying to some threads and taking part in the discussions happening in the Honor Hub?

    What are you waiting for? Start commenting and start winning! Remember to read the instructions posted here.

    Dismiss Notice

Oracle 9i query>>help

Discussion in 'Software Q&A' started by ::cyborg::, Feb 9, 2007.

Thread Status:
Not open for further replies.
  1. ::cyborg::

    ::cyborg:: Member

    Joined:
    Oct 5, 2005
    Messages:
    438
    Likes Received:
    8
    Trophy Points:
    18
    Location:
    NEW DELHI
    hi guys,

    iam realy having a frustrating problem

    when installing oracle 9i i dont know what password i entered at that time but now when iam trying to login to sql*plus a/c iam not able to do so.

    it asks me three things
    1)username
    2)password and
    3)string which i really dont know :(

    plz help me iam a newbie .plz help.

    helpppppp :(

    ::cyborg::
     
  2. gaurav_indian

    gaurav_indian CG Artist

    Joined:
    May 5, 2006
    Messages:
    1,455
    Likes Received:
    2
    Trophy Points:
    0
    Location:
    New Delhi,India
    Check your pm.
     
    ::cyborg:: likes this.
  3. OP
    OP
    ::cyborg::

    ::cyborg:: Member

    Joined:
    Oct 5, 2005
    Messages:
    438
    Likes Received:
    8
    Trophy Points:
    18
    Location:
    NEW DELHI
    hey gaurav dude thanks it worked

    and gauav what if i want my user name and password to be there

    anyway i reped u
     
  4. vinit suri

    vinit suri New Member

    Joined:
    Feb 6, 2007
    Messages:
    87
    Likes Received:
    0
    Trophy Points:
    0
    try this man
    username: scott
    password : tiger
    n leave the string blank...
    k
    also try
    username: sys
    password : manager
    .best of luck
     
  5. OP
    OP
    ::cyborg::

    ::cyborg:: Member

    Joined:
    Oct 5, 2005
    Messages:
    438
    Likes Received:
    8
    Trophy Points:
    18
    Location:
    NEW DELHI
    @vinit scott tiger is ok but sys manager is not working
     
  6. Lucky_star

    Lucky_star Still Shining!

    Joined:
    Nov 10, 2006
    Messages:
    1,208
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Up 'n' above
    If you want to change your password only:
    Code:
    ALTER USER  [I]user[/I]
    IDENTIFIED  [I]password[/I];
    user is the name of the existing user and password is the new password which is to be specified.
    For Ex.
    ALTER USER scott
    IDENTIFIED BY cat;
    User Altered

    If you want to create a new user with a new password, then:
    Code:
    CREATE USER [I]user [/I]
    IDENTIFIED BY [I]password[/I];
    For using that user id You have to grant certain roles and privileges
     
  7. vinit suri

    vinit suri New Member

    Joined:
    Feb 6, 2007
    Messages:
    87
    Likes Received:
    0
    Trophy Points:
    0
    [tats right create new user......best of luck:p:p:p
     
Thread Status:
Not open for further replies.

Share This Page