Database link Remote link databases

--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