Results 1 to 5 of 5
  1. #1
    Join Date
    May 2011
    Posts
    4

    Unanswered: Number of tables per schema

    Im having an oracle-database with six schemas which contains a different number of tables (from 100 to 20). The tables in the schemas are part of the same database, that is, queries are performed via joins on several of them. Would it be a good idea to merge them into one schema? Is there any good reasons for keeping them the way they are?

  2. #2
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    TBH only you can really answer this. But some questions for you to consider:

    Why were separate schemas created?
    Do the existing queries work?
    Is there a real need to change things?
    If you do feel the need to change things, do all tables have unique names?
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    huh. I could have sworn I saw this exact question in the MSSQL forum.

  4. #4
    Join Date
    May 2011
    Posts
    4
    Thats true; I would like answers from both Oracle and Mssql gurus...

  5. #5
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    From your other post:
    it's just a question what 's the best way to design the database
    This is NOT the question you asked here - what DO you really want to know?????
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

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