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
在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