Oracle导入数据

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