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

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


    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.

    • 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
    Where the Surf Meets the Turf @Del Mar, CA
    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
    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
    Liverpool, NY USA
    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.
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  5. #5
    Join Date
    Mar 2009
    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