Dmfldr导入导出文件

Dmfldr导入文件

1. 首先创建一张空表，仅有表结构，没有数据。

 CREATE TABLE TEST (C1 INT,C2 VARCHAR2(20),C3 VARCHAR2)

1. 编写你要传到数据库里的txt文件。

1 'lxq' 'abc'

2 'lxq' 'bcd'

3 'lxq' 'cde'

1. 编写txt文件的控制文件。

LOAD DATA

INFILE '/shujuku/test.txt'

INTO TABLE test

FIELDS '|'

(

C1 TERMINATED BY ' ',

C2 TERMINATED BY ' ',

C3 TERMINATED BY ' '

)

                                                                                                                                                                               

1. 输入导入命令。

./dmfldr userid=SYSDBA/SYSDBA control=\’/shujuku/test/ctrl\’

成功导入到数据库。

Dmfldr导出文件

1. 创建好一张表插入数据并提交

CREATE TABLE TEST (C1 INT,C2 VARCHAR2(20),C3 VARCHAR2)

 

INSERT INTO TEST (1,’LXQ’,’abcdef’);

INSERT INTO TEST (2,’LXQ’,’abcdef’);

INSERT INTO TEST (3,’LXQ’,’abcdef’);

INSERT INTO TEST (4,’LXQ’,’abcdef’);

INSERT INTO TEST (5,’LXQ’,’abcdef’);

INSERT INTO TEST (6,’LXQ’,’abcdef’);

INSERT INTO TEST (7,’LXQ’,’abcdef’);

INSERT INTO TEST (8,’LXQ’,’abcdef’);

INSERT INTO TEST (9,’LXQ’,’abcdef’);

INSERT INTO TEST (10,’LXQ’,’abcdef’);

1. 编写控制文件

LOAD DATA

INFILE '/shujuku/test.txt'

INTO TABLE test

FIELDS '|'

(

C1,

C2,

C3

)

1. 执行导出命令

./dmfldr userid=SYSDBA/SYSDBA@localhost:5236 control=\’/shujuku/test.ctrl/’ LOB_DIRECTORY=\’/shujuku/\’ mode=\’out\’

 

 更多详情前往:htpp://eco.dameng.com