Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2009
    Posts
    5

    Unanswered: Is there any way to organize or group schemas inside an instance?

    Hello,

    I'm using TOad and Oracle 11g.

    I have a lot of shemas inside an instance... How to organize them?
    What I see is a long list of schemas which could be difficult to manage if number of schemas grows up... For example, I'd like to group Schema_1, Schema_2 and Schema_3 in something like Group_1, so it could be seen more organized.

    Group_1
    • Schema_1
    • Schema_2
    • Schema_3


    Sometimes a java or .net application uses 3 or 4 schemas... these schemas are in the same instance which has other schemas for other applications.
    Attached Thumbnails Attached Thumbnails Schemas.JPG  

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I have a lot of shemas inside an instance... How to organize them?
    alphabetically using ORDER BY clause
    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
    Mar 2009
    Posts
    5
    Of course, I can use an Excel to organize schemas, but my question is if Oracle offer some functionality to do it.

  4. #4
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Not in the way you are asking. How many schema s do you have, I currently have about 53000 and I have no problems maintaining them.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  5. #5
    Join Date
    Mar 2009
    Posts
    5
    53000... wow! How do you manage them?

    I mean, I use Toad, listing dropdownbox of Schemas looking for the schema that I need to enter it's quite annoyance for me, even if that list is sorted alphabetically.

    Maybe it's just me and I should access schemas in different way.

Posting Permissions

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