删除临时表,
SELECT sid FROM v$lockWHERE id1 = (SELECT object_id FROM user_objects
WHERE object_name = upper('XXTB'));
WHERE sid in ('70', '16', '67', '130');
ALTER system kill session '16,2077';
ALTER system kill session '67,18474';
select * from dba_db_links;
--drop public database link DBL_xxx ;
create database link DBL_ XXX connect to XXXidentified by XXX
using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = XXX)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ORCL)))';
select * from v_xxx@ XXX;
create public database link DBL_ XXX connect to XXXidentified by XXX
using 'xxxx';
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。