CREATE SYNONYM

Create a synonym.

Syntax:

   CREATE [PUBLIC] SYNONYM [schema.]synonym FOR [schema.]object [@dblink]

You should be aware of the performance hit when accessing data through a synonym.

Related Commands:

DROP SYNONYM
CREATE VIEW

Commands that can use synonyms:

AUDIT
COMMENT
DELETE
EXPLAIN PLAN
GRANT
INSERT
LOCK TABLE
NOAUDIT
REVOKE
SELECT
UPDATE

Related Views:

 DBA_SYNONYMS         ALL_SYNONYMS         USER_SYNONYMS        SYNONYMS 
                                                                PUBLICSYN




Back to the Top

Simon Sheppard
SS64.com