摘要:
说明:请在plsql工具的命令窗口中,依次按步骤执行如下脚本 (1)建立备份表 my_test_log2create table my_test_log2 as select * from my_test_log t where 1=2;(2)创建索引create index ind_userId on my_test_log2(userId);(3)创建存储过程:每天移植数据到my_test_log2CREATE OR REPLACE PROCEDURE MV_MY_TEST_LOGAS BEGIN insert into my_test_log2 select * from my_t... 阅读全文