![]() ![]() CREATE DATABASE LINK for more information on creating database links."Referring to Objects in Remote Databases" for more information on referring to database links.Specify the name of the synonym to be created. You cannot specify a schema for the synonym if you have specified PUBLIC. If you omit schema, then Oracle creates the synonym in your own schema. Specify the schema to contain the synonym. If you do so, then all PL/SQL units that use that name will be invalidated. Take care not to create a public synonym with the same name as an existing schema. ![]() If you create a public synonym and it subsequently has dependent tables or dependent valid user-defined object types, then you cannot subsequently create another database object of the same name as the synonym in the same schema as the dependent objects.A private synonym name must be unique in its schema. If you omit this clause, then the synonym is private and is accessible only within its schema. Oracle uses a public synonym only when resolving references to an object if the object is not prefaced by a schema and the object is not followed by a database link. However each user must have appropriate privileges on the underlying object in order to use the synonym. Public synonyms are accessible to all users. Specify PUBLIC to create a public synonym. You cannot use the OR REPLACE clause for a type synonym that has any dependent tables or valid user-defined object types. Use this clause to change the definition of an existing synonym without first dropping it. Specify OR REPLACE to re-create the synonym if it already exists. To create a PUBLIC synonym, you must have CREATE PUBLIC SYNONYM system privilege. To create a private synonym in another user's schema, you must have CREATE ANY SYNONYM system privilege. To create a private synonym in your own schema, you must have CREATE SYNONYM system privilege. Oracle9i Database Concepts for general information on synonyms ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |