create_synonym
Create a private or public synonym pointing to another schema's table, view, sequence, or procedure. Requires CREATE SYNONYM privilege.
Instructions
Create a private or public synonym pointing at another schema's object. Requires CREATE SYNONYM (private) or CREATE PUBLIC SYNONYM (public); Oracle returns ORA-01031 otherwise.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | No | Schema where the synonym will live (ignored for PUBLIC). Optional — defaults to the server's current schema; omit rather than guess. | |
| synonym | Yes | Synonym name. | |
| isPublic | No | Whether to create a PUBLIC synonym (requires CREATE PUBLIC SYNONYM privilege). | |
| targetName | Yes | Name of the target object (table/view/sequence/procedure). | |
| targetSchema | Yes | Schema of the target object. |