课程第1/2次

阅读模式 · 发表于 2019-9-5 21:54:47

了解直接路径加载：

select * from dba_directories;
create directory dir1 as '/home/oracle/dir1';
select s.segment_name , bytes/1024/1024 from dba_segments s where s.segment_name in ('TBIG','TBIG2') ;
create table hr.tbig as select * from dba_source ;
create table hr.tbig2 as select * from dba_source ;
alter table hr.tbig allocate extent (size 2G);
alter table hr.tbig2 allocate extent (size 2G);

复制代码

alter table hr.tbig enable row movement ;
alter table hr.tbig2 enable row movement;
alter table hr.tbig shrink space;
alter table hr.tbig2 shrink space;
select s.segment_name , bytes/1024/1024 from dba_segments s where s.segment_name in ('TBIG','TBIG2') ;

复制代码

9isqlldr.tgz (933.43 KB, 下载次数: 198)