-
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,
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|