Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2013
    Posts
    4

    Unanswered: I m having some confusion in connecting oralce 11g Xe

    what is the concept of the following , and why it si used

    1. $ system / nolog
    2. sys as sysdba
    3. / as sysdba
    4. connect system

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    SYS & SYSTEM are different schemas in the database.

    Neither the SYS nor the SYSTEM schemas should be used for anything other than Oracle upgrade procedures.
    They should NOT be used for daily access or operation of any Oracle database.
    Last edited by anacedent; 09-26-13 at 14:27.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Sep 2013
    Posts
    4

    sys and system is not only the confusion

    Hi buddy
    First of all i m new to database

    i asked something else , you answered something else,
    i did not ask both sys and system are different schema or not.

    i asked why we use them, if you dont have deep knowledge in data base , or you dont have the caliber to understand the question and answer them, then please stop taunting my friend.


  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You should not use SYS or SYSTEM schemas since they exist only for DB maintenance.
    You should create & utilize own schemas for application development & use.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Sep 2013
    Posts
    4

    thank you

    Hi anacedent

    THank u

  6. #6
    Join Date
    Dec 2007
    Posts
    253

    Thumbs down

    Quote Originally Posted by inamulhaque View Post
    i asked why we use them, if you dont have deep knowledge in data base , or you dont have the caliber to understand the question and answer them, then please stop taunting my friend.
    Personally, I'm sick of seeing posts like this. You were offered perfectly good and valid advice, you responded with aggression and thinly veiled insults. As another poster on another site would say (I'm paraphrasing) "If you don't like the service provided, you can speak to the admin for a full refund of your membership fee"
    Alternatively, you could just reel your neck in when someone takes the time to respond to one of your questions (which could have been answered by looking up the documentation & google if you could be 4rsed.)

  7. #7
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Pablolee, anacedent here = BlackSwan over there, it is the same person.

Posting Permissions

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