用dmfldr工具导入导出
以下是将文本数据导入导出数据库的过程:
1.建表:
CREATE huge TABLE TEST1(C1 INT,C2 INT);
2.插入10000行数据:
insert into TEST1 select level,level from dual connect by level <10001;
commit;
查询行数,
SELECT COUNT(*) FROM TEST1;
3.控制文件准备:
存放路径为/opt/dmdbms/data/DAMENG/test.ctrl
内容如下:
LOAD DATA
INFILE ‘/opt/dmdbms/data/DAMENG/test.txt’
INTO TABLE test1
FIELDS ‘,’
(
c1,
c2
)
4.命令行进入bin目录,进行导出数据
./dmfldr userid=SYSDBA/SYSDBA:5236 control=’/opt/dmdbms/data/DAMENG/test.ctrl’ mode=‘out’
5.打开管理工具, 清空表中数据:
truncate table test1;
6.快速装载导入cd /opt/dmdbms/bin
./dmfldr userid=SYSDBA/SYSDBA:5236 control=’/opt/dmdbms/data/DAMENG/test.ctrl’
7.查询表行数:
select count(*) from TEST1;