删除和创建Oracle数据库中的DBLink

drop database link TEST_LINK;
create database link TEST_LINK
  connect to jiang identified by helloworld
  using '(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.9.192)(PORT=1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = wad192)
    )
  )';


create or replace synonym T_BILL_DETAIL
  for jiang.TEST_TABLE@TEST_LINK;




create or replace view v_test as
select to_char(starttime-1,'yyyymmdd') date from jiang.TEST_TABLE@TEST_LINK where operation='TEST';