同义词
查看所有同义词
- select * from dba_synonyms
- select * from dba_synonyms WHERE SYNONYM_NAME=’SYTEST’
创建远程同义词
- create public synonym table_name for table_name@DB_Link;
创建本地同义词
- create public synonym table_name for user.table_name;
删除同义词
- drop public synonym SYTEST;
查看所有DBLINK
- select * from dba_db_links;
- select * from dba_db_links WHERE DB_LINK=’SYTEST’;
创建DBLINK
- CREATE PUBLIC DATABASE LINK SYTEST CONNECT TO hunchunkj IDENTIFIED BY hunchunkj using ‘192.168.2.30:1521/orcl’;
删除DBlink
- drop public database link dblinkname;