|
|
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