Results 1 to 6 of 6

Thread: Schemas

  1. #1
    Join Date
    Sep 2003
    Posts
    51

    Unanswered: Schemas

    Hi all,

    There are some schemas (MDSYS, OUTLN, DBSNMP, ORDSYS, ORDPLUGINS) that are created just like SYS and SYSTEM. I need to know : what are the use of them ?

    Can I drop all of then ??

    Thanks in advance,

    Antonio Freitas

  2. #2
    Join Date
    Aug 2003
    Posts
    123
    is it a production/development system

  3. #3
    Join Date
    Sep 2003
    Posts
    51
    Originally posted by jaggu
    is it a production/development system
    It's a production system.

  4. #4
    Join Date
    Oct 2003
    Location
    St.Louis,MO
    Posts
    120

    Re: Schemas

    Originally posted by ajfreitas
    Hi all,

    There are some schemas (MDSYS, OUTLN, DBSNMP, ORDSYS, ORDPLUGINS) that are created just like SYS and SYSTEM. I need to know : what are the use of them ?

    Can I drop all of then ??

    Thanks in advance,

    Antonio Freitas
    Oracle documentation on this matter is here......
    http://download-east.oracle.com/docs...db.htm#1006823

  5. #5
    Join Date
    Aug 2003
    Posts
    123

    Re: Schemas

    ckeck the owner of the schemas and check any body logged in with that user id, if you could locate the him/her check with them. If you could not find the user created the schema, lock the schema for sime time if no one ask for that delete it later.

  6. #6
    Join Date
    Sep 2003
    Posts
    51

    Re: Schemas

    Originally posted by tlael
    Oracle documentation on this matter is here......
    http://download-east.oracle.com/docs...db.htm#1006823
    You solved my problem !!
    Thanks.

    Antonio Freitas

Posting Permissions

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