先简历一个到db1的db link,类似: CREATE [PUBLIC] DATABASE LINK db1 CONNECT TO <user_name> IDENTIFIED BY <password> USING 'db1'; 然后使用sql如"select * from all_objects@db1 where owner='CSM' and object_type='TABLE'"得到改用户下面的所有表名的游标,迭代游标利用这些表名动态生成生成sql如: create table a as select * from a@db1
怎么没人回啊?
可能是用copy from语句,
求高手指点!
CREATE [PUBLIC] DATABASE LINK db1
CONNECT TO <user_name>
IDENTIFIED BY <password>
USING 'db1';
然后使用sql如"select * from all_objects@db1 where owner='CSM' and object_type='TABLE'"得到改用户下面的所有表名的游标,迭代游标利用这些表名动态生成生成sql如:
create table a as select * from a@db1