一、导出
方法1:
spool d:\emp0130.txt
select * from emp;
spool off
方法1:
spool d:\emp0130.txt
select * from emp;
spool off
方法2:
set trimspool on
set linesize 420
set pagesize 2000
set newpage 1
set heading off
set term off
set echo off
spool d:\emp.txt
select empno||','||ename||','||job||','||mgr||','||hiredate||','||sal||','||deptno from emp;
spool off
set trimspool on
set linesize 420
set pagesize 2000
set newpage 1
set heading off
set term off
set echo off
spool d:\emp.txt
select empno||','||ename||','||job||','||mgr||','||hiredate||','||sal||','||deptno from emp;
spool off
其中方法二要快些且将列人为用逗号隔开
二、导入
1.新建文本命名为control.ctl并写入以下内容
load data
infile 'D:\emp0130.txt'
append into table emp
fields terminated by ','
(empno,ename,job,mgr,hiredate,sal,comm,deptno)
二、导入
1.新建文本命名为control.ctl并写入以下内容
load data
infile 'D:\emp0130.txt'
append into table emp
fields terminated by ','
(empno,ename,job,mgr,hiredate,sal,comm,deptno)
2.建表结构
-- Create table
create table EMP
(
EMPNO NUMBER(4) not null,
ENAME VARCHAR2(10),
JOB VARCHAR2(9),
MGR NUMBER(4),
HIREDATE DATE,
SAL NUMBER(7,2),
COMM NUMBER(7,2),
DEPTNO NUMBER(2)
)
-- Create table
create table EMP
(
EMPNO NUMBER(4) not null,
ENAME VARCHAR2(10),
JOB VARCHAR2(9),
MGR NUMBER(4),
HIREDATE DATE,
SAL NUMBER(7,2),
COMM NUMBER(7,2),
DEPTNO NUMBER(2)
)
3.运行以下脚本
sqlldr userid=luoluo/luoluo control=d:\control.ctl direct=true
sqlldr userid=luoluo/luoluo control=d:\control.ctl direct=true
另:alter table emp nologging会快N多
-------
原文地址: