alter database datafile '/oracle/app/oracle/oradata/test/users01.dbf' resize 100m; SQL>&nb..."/>
您好,登錄后才能下訂單哦!
--1. 構(gòu)造測(cè)試數(shù)據(jù)
SQL> alter database datafile '/oracle/app/oracle/oradata/test/users01.dbf' resize 100m; SQL> create table ducw.test_dul tablespace users 2 as 3 select * from dba_objects; SQL> select count(1) from ducw.test_dul; SQL> exit;
--2. 構(gòu)造DUL使用的控制文件
在control.dul中必須包含SYSTEM表空間的文件信息,以及想U(xiǎn)NLOAD的表的表空間文件信息。
SQL> select ts# || ' '|| rfile# || ' '|| name || ' block_size '|| block_size 2 from v$datafile 3 / TS#||''||RFILE#||''||NAME||'BLOCK_SIZE'||BLOCK_SIZE -------------------------------------------------------------------------------- 0 1 /oracle/app/oracle/oradata/test/system01.dbf block_size 8192 1 2 /oracle/app/oracle/oradata/test/sysaux01.dbf block_size 8192 2 3 /oracle/app/oracle/oradata/test/undotbs01.dbf block_size 8192 4 4 /oracle/app/oracle/oradata/test/users01.dbf block_size 8192 4 5 /oracle/app/oracle/oradata/test/users02.dbf block_size 8192
--2.1 DUL控制文件
(python3venv) [oracle@sqlaudit ~]$ cat control.dul 0 1 /oracle/app/oracle/oradata/test/system01.dbf block_size 8192 1 2 /oracle/app/oracle/oradata/test/sysaux01.dbf block_size 8192 2 3 /oracle/app/oracle/oradata/test/undotbs01.dbf block_size 8192 4 4 /oracle/app/oracle/oradata/test/users01.dbf block_size 8192 4 5 /oracle/app/oracle/oradata/test/users02.dbf block_size 8192
--2.2 DUL參數(shù)文件
(python3venv) [oracle@sqlaudit ~]$ cat init.dul #Platform specific parameter OSD_BIG_ENDIAN_FLAG=FALSE OSD_DBA_FILE_BITS=10 OSD_C_STRUCT_ALIGNMENT=32 OSD_FILE_LEADER_SIZE=1 OSD_WORD_SIZE=32 # Size of dul dictionary caches. If one of these is too low startup will fail. DC_COLUMNS=200000 DC_TABLES=100000 DC_OBJECTS=100000 DC_USERS=100 DC_SEGMENTS=100000 # Location and filename ofthe control file CONTROL_FILE=/home/oracle/control.dul # Database blocksize DB_BLOCK_SIZE=8192 # Using Import to restore the data retrieved EXPORT_MODE=TRUE # Using SQL*Loader to restore the data retrieved #EXPORT_MODE=FALSE # Compatible parameter COMPATIBLE=10 FILE_SIZE_IN_MB=1000 BUFFER=200000000
--3. 運(yùn)行DUL
rm *.ctl rm *.dat rm *.log rm *.ddl rm *.out
--3.1 在DUL運(yùn)行環(huán)境下執(zhí)行BOOTSTRAP命令,生成字典信息,為UNLOAD做必要的準(zhǔn)備。
(python3venv) [oracle@sqlaudit ~]$ ./dul DUL> bootstrap;
--3.2 在DUL運(yùn)行環(huán)境下執(zhí)行UNLOAD過程:
UNLOAD TABLE owner.table ;
This will unload the one table definition and the table's data.
UNLOAD USER user name ;
This unloads all tables and data for the specified user.
UNLOAD DATABASE ;
This unloads all of the database tables available. (except the user SYS).
DUL> unload table ducw.test_dul;
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。