expPFILE
file = '/opt/01/backup1.dmp', '/opt/01/backup2.dmp', '/opt/01/backup3.dmp',
'/opt/01/backup4.dmp', '/opt/01/backup5.dmp', '/opt/01/backup6.dmp',
'/opt/01/backup7.dmp', '/opt/01/backup8.dmp', '/opt/01/backup9.dmp',
'/opt/01/backup10.dmp', '/opt/01/backup11.dmp', '/opt/01/backup12.dmp',
'/opt/01/backup13.dmp', '/opt/01/backup14.dmp', '/opt/01/backup15.dmp',
'/opt/01/backup16.dmp', '/opt/01/backup17.dmp', '/opt/01/backup18.dmp',
'/opt/01/backup19.dmp', '/opt/01/backup20.dmp'
log = '/opt/01/backup.log'
owner = Hemes
rows = y
grants = y
direct = y
filesize = 2G
impPFILE
file = '/opt/01/backup1.dmp', '/opt/01/backup2.dmp', '/opt/01/backup3.dmp',
'/opt/01/backup4.dmp', '/opt/01/backup5.dmp', '/opt/01/backup6.dmp',
'/opt/01/backup7.dmp', '/opt/01/backup8.dmp', '/opt/01/backup9.dmp',
'/opt/01/backup10.dmp', '/opt/01/backup11.dmp', '/opt/01/backup12.dmp',
'/opt/01/backup13.dmp', '/opt/01/backup14.dmp', '/opt/01/backup15.dmp',
'/opt/01/backup16.dmp', '/opt/01/backup17.dmp', '/opt/01/backup18.dmp',
'/opt/01/backup19.dmp', '/opt/01/backup20.dmp'
log = '/opt/01/recovery.log'
fromuser = Hemes
touser = Hemes
rows = y
grants = y
commit = y
ignore = y
filesize = 2G
$ exp system/sys PARFILE = '/opt/oracle/migrate_lmgf01/expPFILE'
$ imp system/sys PARFILE = '/opt/oracle/migrate_lmgf01/impPFILE'
导入导出
最新推荐文章于 2023-04-23 16:13:39 发布