Oracle导入数据

[MartriWang]

oracle导入数据：

在SQL*plus中：

1.@ c:/test.sql

2.imp

3.impdp(server端)

a.conn sys/sys as sysdba;

b.creat directory dumpin_idr as 'd:\dump';

c.grant read,write on directory dumpin_dir to scott;

d.impdp scott/tiger directory=dumpin_dir dumpfile=DUMPTAB.DMP tables =dept,emp

 

 

---

MartriWang

2007-04-08