two DBs with database link vs. one DB with 2 schemas
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: two DBs with database link vs. one DB with 2 schemas

  1. #1
    Join Date
    Apr 2001
    Posts
    257

    two DBs with database link vs. one DB with 2 schemas

    We currently have two databases: DB1 has schema under user A and DB2 has schema under user B. They are linked via database links and referenced via synonyms.

    I'd like to merge them into one DB. Can I simply import user A's schema to DB2 and modify synonyms (ie., in USER_SYNONYMS, set the DB_LINK column to NULL and set the TABLE_OWNER column to user A)?

    Thanks,

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Having two dbs is a resoruce consumer, but its eases the management (indipendent of one another). If you think both the instances serve the same purpose( i.e. taking one down would majorly effect the other, like it virtually effects the other) then I would suggest that you go ahead and merge them to gether. If its vice versa, then keeping them different is my advice.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

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



Click Here to Expand Forum to Full Width