使用CREATE OR REPLACE SYNONYM时可能遇到的常见问题及解决方法 权限问题: 问题描述:在创建同义词时,用户需要具有相应的权限。如果用户没有足够的权限,将无法创建同义词。 解决方法:联系数据库管理员为用户授予相应的权限。例如,要创建私有同义词,用户需要具有CREATE SYNONYM权限;要创建公有同义词,用户需要
CREATE[ORREPLACE] [PUBLIC]SYNONYMschema.synonym_nameFORschema.object;Code language:SQL (Structured Query Language)(sql) In this syntax: First, specify the name of the synonym and its schema. If you skip the schema, Oracle will create the synonym in your own schema. Second, provide the object...
CREATE [OR REPLACE] [PUBLIC] SYNONYM [ schema.] 同义词名称 FOR [ schema.] object [ @dblink ]; --专有(私有)同义词 CREATE SYNONYM SYSN_TEST FOR TEST; --公共同义词 CREATE PUBLIC SYNONYM PUBLIC_TEST FOR TEST; 如果要创建一个远程的数据库上的某张表的同义词,需要先创建一个Database Link(数...
参照: シノニムの概要については、『Oracle Database概要』を参照してください。 前提条件自分のスキーマ内にプライベート・シノニムを作成する場合は、CREATE SYNONYMシステム権限が必要です。他のユーザーのスキーマ内にプライベート・シノニムを作成する場合は、CREATE ANY SYNONYMシステム...
CREATE [ OR REPLACE ] [ PUBLIC ] SYNONYM [ synonym_schema. ]synonym_name FOR [ object_schema. ]object_name; 参数说明 参数描述 OR REPLACE 表示如果要创建的同义词名称已存在,则使用新的定义重新创建同义词。 PUBLIC 指定PUBLIC 来创建公共同义词,所有用户都可以使用。用户必须对基础对象具有相应的权限才...
To create aPUBLICsynonym, you must have theCREATEPUBLICSYNONYMsystem privilege. Syntax create_synonym::= Description of the illustration create_synonym.eps Semantics OR REPLACE SpecifyORREPLACEto re-create the synonym if it already exists. Use this clause to change the definition of an existing syno...
You must have the CREATE PUBLIC SYNONYM privilege to create a public synonym. Oracle will resolve object names in the schema first, so a public synonym will only be used if the object name is not prefaced with a schema name or followed by @dblink and if the object name does not exist ...
Specifies the name of the object to which the synonym will refer. It may include a reference to a remote database by appending the @dblinksyntax. Oracle resolves object names in the current schema first, so a PUBLIC synonym will only be used if the object name is not prefaced with a sc...
Oracle中,`CREATE PUBLIC SYNONYM`语句用于创建公有同义词,所有用户均可访问。题目中的语句`CREATE PUBLIC SYNONYM parts FOR Scott.inventory;`明确包含`PUBLIC`关键字,因此为`Scott.inventory`创建的是一个公有同义词`parts`。 **逐项分析**: - **A**:同义词的创建不涉及对象权限的分配,错误。 - **B**:...
Oracle Database - Enterprise Edition - Version 11.2.0.4 and later: Create public synonym fails with error ORA-38818