移动表到另外的表空间
alter table aud$_bak move tablespace TBS_HEBEI_TEST;
alter table sys.aud$ move tablespace TBS_HEBEI_TEST;
alter index sys.I_AUD1 rebuild tablespace TBS_HEBEI_TEST; 索引失效，必须重建
--创建DBLINK
CREATE DATABASE LINK hygw2
CONNECT TO hygw2 IDENTIFIED BY hygw2
USING 'ora11g';   -- sid
   drop DATABASE LINK hygw3
-- oracle 并行
   select /*+parallel(t 4) */ * from t_student t;
alter session enable parallel dml;
select count(*) from t_student_bak t;
Insert /*+parallel(t 2) */ into t_student_bak t select /*+parallel(t1 2) */ * from t_student t1;
select /*+parallel(t 4) */t.t_major, count(*)
from t_student_bak t, t_subject a
where t.t_major = a.t_major
group by t.t_major;
----------------------------------------------------------
     *
    ***
   *****
*******
   *****
    ***
     *
--------------------------------

ITPub博客

69

最新文章