--authorization to create, delete DblinkGRANT CREATE [ Public] DATABASELINK,DROP [ Public] DATABASELINK toCanco;--View Database Global_name (database name)SELECT * fromGlobal_name; --See which dblink are availableSelectOwnerobject_name fromDba_objectswhereObject_type='DATABASE LINK'; --Delete DblinkDROP [ Public] DATABASELINK NBCB; --=========================================================================================================== ============================================ --Create DblinkCreate Databaselink local218 Connect toCanco identified by"123the Using'( description= (address_list= (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.218) (PORT = 1521))) (Connect_data= (server= Dedicated) (SERVICE_NAME=NBCB )))';--Create synonyms (hide linked databases)CreateSynonym nbcb_fa_monthout_t fornbcb_fa_monthout_t@local218; --=========================================================================================================== ============================================= --TRUNCATE statement cannot be executed --1. Create a process in the target database Create or Replace procedureREMOTE_EXECUTEDDL (SQLTextinch varchar2) AuthidCurrent_User as begin Executeimmediate sqltext; EndRemote_executeddl;--2. Pass the SQL that needs to be executedRemote_executeddl@nbcb('TRUNCATE TABLE canco.nbcb_fa_monthout_t'); --=========================================================================================================== =============================================
Database link Remote link databases