学习
实践
活动
工具
TVP
写文章

Oracle synonym 同义词创建与删除

Oracle synonym 同义词   1、Oracle synonym 同义词是数据库当前用户通过给另外一个用户的对象创建一个别名,然后可以通过对别名进行查询和操作,等价于直接操作该数据库对象。    3、Oracle synonym 同义词按照访问权限分为私有同义词、公有同义词。   4、私有同义词:私有同义词只能当前用户可以访问,前提:当前用户具有create synonym 权限。    语法结构:   CREATE [OR REPLACE] [PUBLIC] SYSNONYM [当前用户.]synonym_nameFOR [其他用户.]object_name; 解析:   1、create 代码如下:     create synonym stuinfo_copy for school.stuinfo;   创建同义词之后,即可使用select *from stuinfo_copy 进行查询 语法结构:   DROP [PUBLIC] SYNONYM [用户.]sysnonym_name;

33510

SQL基础--> 序列(SEQUENCE)、同义词(SYNONYM)

CREATE PUBLIC SYNONYM 2.创建同义词 CREATE [PUBLIC] SYNONYM synonym_name FOR object; 3.查看同义词 DBA_OBJECTS PUBLIC SYNONYM DEPARTMENT FOR scott.dept; Synonym created. ; Synonym created. SQL> GRANT DROP ANY SYNONYM ,DROP PUBLIC SYNONYM TO scott; Grant succeeded. SQL> DROP PUBLIC SYNONYM DEPARTMENT; Synonym dropped.

43320
  • 广告
    关闭

    2022腾讯全球数字生态大会

    11月30-12月1日,邀您一起“数实创新,产业共进”!

  • 您找到你想要的搜索结果了吗?
    是的
    没有找到

    使用datapump 导出导入同义词(export and import synonym using datapump)

    /SYNONYM:\"IN \(SELECT synonym_name FROM dba_synonyms WHERE table_owner=\'GOEX_ADMIN\'\)\" Export: Release /SYNONYM:"IN (SELECT synonym_name FROM dba_synonyms WHERE table_owner='GOEX_ADMIN')" Estimate in progress /SYNONYM Master table "GOEX_ADMIN"." Processing object type DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/SYNONYM ORA-31684: Object type SYNONYM: GO_GA_SYS_DATAPUMP_PARA_TBL" already exists ORA-31684: Object type SYNONYM:"PUBLIC"."

    66430

    【colab pytorch】FutureWarning: Passing (type, 1) or 1type as a synonym of type is deprecated; in a

    pip install tensorflow==2.0.0-alpha0 再运行时就会报: FutureWarning: Passing (type, 1) or '1type' as a synonym

    35310

    Elasticsearch 自定义分词同义词环节的这个细节不大好理解......

    扩展背景描述: 这是 Elasticsearch 自定义分词 Text analysis 章节 Token filter reference 小节的 同义词 token 过滤 (Synonym token ] } }, "filter": { "synonym": { "type": "synonym", 自定义分词器的名字:synonym。 tokenizer 使用:whitespace 空白分词器。 filter 也就是 token filter 使用:synonym 同义词实现。 3.2 token filter 细节参数解读 参数 1 —— "type": "synonym" 含义:同义词类型。 ] } }, "filter": { "synonym": { "type": "synonym",

    29040

    【2019年8月版本】OCP 071认证考试最新版本的考试原题-第10题

    A) A synonym can have a synonym. B) All private synonym names must be unique in the database. C) Any user can create a PUBLIC synonym. D) A synonym can be created on an object in a package. E) A synonym has an object number. (解析: 实验证明可以为同义词创建同义词; 同义词也是 Oracle 的一个对象; synonym 需要授权才能够创建; )

    42320

    同名的同义词和视图解惑

    SQL> create public synonym v$bisal for v_$bisal; Synonym created. SQL> create public synonym v$bisal for v_$bisal; Synonym created. 再测试几个例子,不能创建两个同名的公共同义词, SQL> create public synonym a for dba_tables; Synonym created. SQL> create synonym a for user_tables; create synonym a for user_tables * ERROR at line SQL> create synonym a for dba_tables; Synonym created.

    17630

    Oracle数据导出新选择

    1999992,BD_ADMIN,DSK_FUNC_IDX_PARAM,SYNONYM 1999993,BD_ADMIN,DSK_FUNC_FIN_TYP,SYNONYM 1999994,BD_ADMIN ,DSK_FUNC_FIN,SYNONYM 1999995,BD_ADMIN,DSK_DB_CFG,SYNONYM 1999996,BD_ADMIN,DSK_DATA_SOUR_SUP,SYNONYM 1999997,BD_ADMIN,DSK_DATA_SOUR_DEF,SYNONYM 1999998,BD_ADMIN,DSK_DATA_SOUR,SYNONYM 1999999,SYS,WRH$_DB_CACHE_ADVICE 1999992,BD_ADMIN,DSK_FUNC_IDX_PARAM,SYNONYM 1999993,BD_ADMIN,DSK_FUNC_FIN_TYP,SYNONYM 1999994,BD_ADMIN ,DSK_FUNC_FIN,SYNONYM 1999995,BD_ADMIN,DSK_DB_CFG,SYNONYM 1999996,BD_ADMIN,DSK_DATA_SOUR_SUP,SYNONYM

    18720

    总结一些ES不常用的filter

    示例如下: PUT /synonym_example { "settings": { "analysis" : { "analyzer" "my_synonym" : { "type" : "synonym", "synonyms_path" : "analysis/synonym.txt" } } } } } 我们需要在ES实例的config 目录下,新建一个analysis/synonym.txt的文件,内容如下: 番茄,西红柿,圣女果 记得要重启。 然后测试下, GET /synonym_example/_analyze { "analyzer": "synonym", "text": "番茄" } 输出, { "tokens" :

    38230

    【DB笔试面试514】在Oracle中,同义词的定义及其作用是什么?有关同义词需要注意些什么?

    创建同义词必须要有 CREATE ANY SYNONYM、CREATE SYNONYM 系统权限。要创建全局的同义词,必须有CREATE PUBLIC SYNONYN 系统权限。 EMP FOR SCOTT.EMP; Synonym created. create a synonym with same name as object LHR@ora11g > create public synonym s_b for s_b; Synonym created LHR@ora11g > create public synonym s_a for s_b; Synonym created. object LHR@ora11g > create public synonym s_b for s_b; Synonym created.

    36110

    Oracle中的PUBLIC(r10笔记第14天)

    首先我们创建一个public的synonym,我们看看这个public的含义。 SQL> create public synonym test for n1.test; Synonym created. ----------------- -------------------------------------- TEST PUBLIC SYNONYM ='PUBLIC'; no rows selected 大体而言,public两种表现形式 一种是创建public的对象,都是在PUBLIC的这个owner下 create public synonym SQL> select * from dba_synonyms where synonym_name='TEST'; OWNER SYNONYM_NAME

    44540

    同名的同义词和视图解惑

    SQL> create public synonym v$bisal for v_$bisal; Synonym created. SQL> create public synonym v$bisal for v_$bisal; Synonym created. 再测试几个例子,不能创建两个同名的公共同义词, SQL> create public synonym a for dba_tables; Synonym created. SQL> create synonym a for user_tables; create synonym a for user_tables * ERROR at line SQL> create synonym a for dba_tables; Synonym created.

    23620

    使用shell脚本生成只读权限的sql脚本(r2第28天)

    object_name||' to '||' ${conn_schema};'; spool off; spool conn_${conn_schema}_syn.sql select 'create synonym VIEW','SEQUENCE','PROCEDURE','FUNCTION','PACKAGE') and owner=upper('$source_schema') group by 'create synonym grant execute on cnvdbo8.ffff to cnvdbc8; create synonym cnvdbo8.aaaa; create synonym bbbb; create synonym

    39370

    ES 字符过滤器&令牌过滤器

    "analyzer": { "custom_analyzer":{ "tokenizer":"ik_max_word", "filter":["synonym "] } }, "filter": { "synonym":{ "type": "synonym", "synonyms_path " : [ { "token" : "嘻嘻", "start_offset" : 0, "end_offset" : 3, "type" : "SYNONYM }, { "token" : "嘻嘻", "start_offset" : 4, "end_offset" : 6, "type" : "SYNONYM }, { "token" : "嘎嘎", "start_offset" : 4, "end_offset" : 6, "type" : "SYNONYM

    5140

    曲折的10g,11g中EM的安装配置过程(r4笔记第98天)

    10g中的EM相对比较简单,如果新建由于种种原因失败,重新创建的时候,很可能sysman用户没有删除,还存在一些role和public synonym. 最后通过select *from dba_synonyms where synonym_name like 'MGM%' 来查看关联的MGM相关的public synonym,发现竟然有差不多300多个 public synonym,这些public synonym是无法通过drop user sysman cascade来删除的,只能指定删除。 select 'DROP '||OWNER||' SYNONYM '||SYNONYM_NAME||';' from dba_synonyms where TABLE_owner='SYSMAN'; 发现是将近20个这样的public synonym 再次清理,就顺顺利利完成了EM的安装。

    40130

    Elasticsearch7学习笔记之_doc类型被取消

    "mappings": [ ", => " ] } }, "filter": { "my_synonym_filter ": { "type": "synonym", "expand": true, "synonyms": [ "lileilei "char_filter": [ "my_char_filter" ], "filter": [ "my_synonym_filter "mappings": [ ", => " ] } }, "filter": { "my_synonym_filter ": { "type": "synonym", "expand": true, "synonyms": [ "lileilei

    56840

    MyBatis批量新增和更新

    VARCHAR" /> <result column="pinyin" property="pinyin" jdbcType="VARCHAR" /> <result column="<em>synonym</em> " property="<em>synonym</em>" jdbcType="VARCHAR" /> <result column="create_date" property="createDate" jdbcType parameterType="java.util.List"> insert into words (word_no, value, filed_class, pinyin, synonym (#{ item.wordNo},#{ item.value},#{ item.filedClass},#{ item.pinyin}, #{ item.synonym = null" > synonym = #{item.synonym,jdbcType=VARCHAR}, </if> <if test=

    37720

    自动微分和梯度带

    site-packages/tensorflow/python/framework/dtypes.py:516: FutureWarning: Passing (type, 1) or '1type' as a synonym site-packages/tensorflow/python/framework/dtypes.py:517: FutureWarning: Passing (type, 1) or '1type' as a synonym /tensorboard/compat/tensorflow_stub/dtypes.py:541: FutureWarning: Passing (type, 1) or '1type' as a synonym /tensorboard/compat/tensorflow_stub/dtypes.py:542: FutureWarning: Passing (type, 1) or '1type' as a synonym /tensorboard/compat/tensorflow_stub/dtypes.py:543: FutureWarning: Passing (type, 1) or '1type' as a synonym

    32510

    mysql数据库信息函数

    GraphML document representing memory role subgraphs ROW_COUNT() The number of rows updated SCHEMA() Synonym for DATABASE() SESSION_USER() Synonym for USER() SYSTEM_USER() Synonym for USER() USER() The user name

    7520

    通过shell脚本得到数据字典的信息 (r2笔记72天)

    VIEW PUBLIC 3306 USER_OBJECTS SYNONYM synonym_details OWNER SYNONYM_NAME ------------------------------ ------- INDEX', 2, 'TABLE', 3, 'CLUSTER', 4, 'VIEW', 5, 'SYNONYM OBJECT_ID,DATA_OBJECT_ID,OBJECT_NAME,OBJECT_TYPE FROM DBA_OBJECTS WHERE OBJECT_NAME=UPPER('$1'); prompt synonym_details SELECT OWNER,SYNONYM_NAME FROM DBA_SYNONYMS WHERE SYNONYM_NAME=upper('$1'); prompt view_details SELECT

    46070

    扫码关注腾讯云开发者

    领取腾讯云代金券