CREATE VIEW TEST_V AS
SELECT
utl_raw.cast_to_raw(DJ_NSRXX.NSRMC) nsrmc
FROM
DJ_NSRXX@LANDTAXDBLINKdrop view TEST_V@landtaxdblink 删除会提示oracledblink 视图
SELECT
utl_raw.cast_to_raw(DJ_NSRXX.NSRMC) nsrmc
FROM
DJ_NSRXX@LANDTAXDBLINKdrop view TEST_V@landtaxdblink 删除会提示oracledblink 视图
SELECT
utl_raw.cast_to_raw(DJ_NSRXX.NSRMC) nsrmc
FROM
DJ_NSRXX@LANDTAXDBLINK
?如果确定这个视图在其他数据库,可以使用如下语句:
BEGIN
dbms_utility.exec_ddl_statement@LANDTAXDBLINK('drop VIEW TEST_V');
END;
BEGIN
SELECT COUNT(1) INTO FLAG FROM user_views@LANDTAXDBLINK s WHERE s.view_name = 'yourViewName';
IF FLAG = 1 THEN
dbms_utility.exec_ddl_statement@LANDTAXDBLINK('drop VIEW yourViewName');
END IF;
END;