View Single Post
  #2 (permalink)  
Old 01-06-09, 17:23
buckeye234 buckeye234 is offline
Registered User
 
Join Date: Sep 2002
Location: Ohio
Posts: 204
You don't mention Oracle Version or OS and version, but I guess it doesn't matter in this case.

Do you have any tools at your disposal. I would use TOAD to make quick work of this problem.

Otherwise, you could write a query against the DBA_SYNONYMS view in the test database to generate the create synonym commands you need, spool the ouput to a text file and then run this against the production database.

Something along the lines of:
Code:
SELECT 'CREATE SYNONYM '||synonym_name||' for '||table_owner||'.'||table_name||';'
FROM dba_synonyms
WHERE owner = 'user1';
Didn't test, but I think it should be OK.
Reply With Quote