摘要: analyze table counterdb compute statistics; 记录不对 执行select * from (select t.table_name as tableID,t.num_rows as recordCount from user_tables t) tt where tt.tableID='COUNTERDB' 统计表 COUNTERDB 记录数 阅读全文
posted @ 2011-09-07 18:32 小さいです哥 阅读(343) 评论(0) 推荐(0)
摘要: create database link creditID connect to CREDIT_MANAGE identified by Passwordusing '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.20.10.67)(PORT=1521))(CONNECT_DATA=(SID=TEST)))'; 阅读全文
posted @ 2011-09-07 13:05 小さいです哥 阅读(150) 评论(1) 推荐(1)