DBA Hub

📋Steps in this guide1/1

Create/drop synonyms

-- Create public synonym

oracle configurationintermediate
by OracleDba
16 views
1

Create/drop synonyms

-- Create public synonym -- Create private synonym -- Drop synonym -- View synonym related info

Code/Command (click line numbers to comment):

1
2
3
4
5
CREATE PUBLIC SYNONYM emp_view FOR scott.emp;
CREATE SYNONYM priv_view FOR scott.emp;
DROP PUBLIC SYNONYM emp_view;
DROP SYNONYM priv_view;
SELECT * FROM DBA_SYNONYMS;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!