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
扫一扫
1648
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
