oracle synonym dblink

--show current schema
select sys_context('userenv','current_schema') from dual;

--create dblink,if u want to link databaseA at databaseB,u should create dblink of B at A
create public database link DBLK_test1 connect to schema1 identified by schema1 using '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=your host)(PORT=1521))(CONNECT_DATA=(SID=your sid)))';

--show dblink
select owner,object_name from dba_objects where object_type='DATABASE LINK';--and owner ='your owner';

--delete public dblink
DROP public DATABASE LINK DBLK_test1;
--delete private dblink,equals "DROP DATABASE LINK current_schema.DBLK_test1;"
DROP DATABASE LINK DBLK_test1;

--show synonym
select * from all_synonyms where upper(synonym_name) like upper('%test%')

--delete public
drop public synonym ASYNONYM1_1;
--delete private synonym,equals "drop synonym current_schema.ASYNONYM1_1;"
drop synonym ASYNONYM1_1;

--create private synonym
CREATE OR REPLACE  SYNONYM IKOUTEST.a_synonym_test1 FOR schema2.a_synonym_table_test1@DBLK_test1;

--use synonym to select db
select * from  IKOUTEST.a_synonym_test1;
select * from  a_synonym_test1;