ALTER USER scott ACCOUNT UNLOCK;
ALTER USER scott IDENTIFIED BY shlzghli;
按用户:exp bigtide2012/bigtide owner=bigtide2012 file=/u01/app/oracle/10G/bigtide2012.dmp log=/u01/app/oracle/10G/bigtide2012.log buffer=1000000 feedback=50000 compress=n ;
exp bigtidekd/bigtide owner=bigtidekd file=/u01/app/oracle/10G/bigtidekd.dmp log=/u01/app/oracle/10G/bigtidekd.log buffer=1000000 feedback=50000 compress=n ;
exp songs/bigtide owner=songs file=/u01/app/oracle/10G/songs.dmp log=/u01/app/oracle/10G/songs.log buffer=1000000 feedback=50000 compress=n ;
用DIRECTORY的相应选项值,示例如下:
expdp scott/tiger DIRECTORY=dump DUMPFILE=a.dmp logfile=a.log
16. NETWORK_LINK
指定数据库链名,如果要将远程数据库对象导出到本地例程的转储文件中,必须设置该选项.
expdp中使用连接字符串和network_link的区别:
expdp属于服务端工具,而exp属于客户端工具,expdp生成的文件默认是存放在服务端的,而exp生成的文件是存放在客户端.
expdp username/password@connect_string //对于使用这种格式来说,directory使用源数据库创建的,生成的文件存放在服务端。
right:
imp bigtide2012/shlzghli touser=bigtide2012 fromuser=bigtide2012 file=D:\10G\bigtide2012.dmp log = D:\10G\bigtide2012.log buffer=1000000 feedback=50000 ;
imp bigtidekd/shlzghli touser=bigtidekd fromuser=bigtidekd file=D:\10G\bigtidekd.dmp log=D:\10G\bigtidekd.log buffer=1000000 feedback=50000 ;
imp SONGS/shlzghli touser=SONGS fromuser=SONGS file=D:\10G\songs.dmp log = D:\10G\songs.log buffer=1000000 feedback=50000 ;
imp BIGTIDE2012/shlzghli touser=BIGTIDE2012 fromuser=BIGTIDE2012 file=D:\10G\EAS_D_BTLX_STANDARD.dmp log = D:\10G\EAS_D_BTLX_STANDARD.log buffer=1000000 feedback=50000 ;
exp system/manager@TEST file=d:\daochu.dmp tables=(table1,table2)
将d:\daochu.dmp中的表table1 导入
imp system/manager@TEST file=d:\daochu.dmp tables=(table1)