Question

oracle中导出和导入数据库备份文件分别用什么命令

Answer 1

导出：exp PECARD_HN/PECARD_HN@192.168.141.40:1521/orcl file=E:\work\dmp\PECARD_HN.dmp
导入：imp PECARD_HN/PECARD_HN@127.0.0.1:1521/orcl file=E:\work\dmp\PECARD_HN.dmp full=y

Answer 2

exp user/password@sid file=d:\111.dmp tables=(tablename)---导出
imp user/password@sid file=d:\111.dmp ----导入

Answer 3

导入 imp username/passwd@conn_str
导出 exp username/passwd@conn_str