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,