Oracle 导入导出数据库

# 导入数据库

imp projectname/123456@ora9i file=E:\projectdb\projectdb20071205.dmp  full=y ignore=y

 

# 导出数据库

exp projectname/123456@ora9i file=projectdb20071205.dmp

 

 

imp projectname/123456@ora9i fromuser=username1 touser=username2 ignore=y file=expfile.dmp full=y

 

#远程服务器数据库导入导出操作

exp user/pwd@server2_192.168.1.2 buffer=30000000 file=G:\20100816.dmp log=G:\20100816.log;

 

imp user/pwd@server2_192,168.1.2 buffer=30000000