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

2025-03-10 11:58:08
推荐回答(3个)
回答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

回答2:

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

回答3:

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