![]() ![]() Object_name specifies either a table, view, sequence, materialized view, type, procedure, function or package as appropriate.ĭatabase_link_name specifies the database link identifying the remote database and schema in which the object specified in object_name is located.Ī synonym must be a uniquely named object for its schema. Omitting this parameter uses the schema of the creator as the schema of the object. Schema specifies the schema of the object specified in object_name. Synonym_name specifies the alternate object name to be referenced by users and applications. Public synonyms can be created only by a user with CREATE PUBLIC SYNONYM system privilege. Omitting this parameter makes a synonym private, and usable only by the creator. PUBLIC is a keyword specifying that this synonym is available to all users. ![]() The syntax to create a synonym is: CREATE synonym_name ![]() To simplify remote table access through database links, a synonym can allow single-word access to remote data, hiding the specific object name and the location from users of the synonym. You can create synonyms for the following:Īll synonyms are schema objects that are stored in the data dictionary of the database in which they are created. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |