imp sunyard/sunyard file=D:\databasebackup\system.DMP full=Y;我想用sunyard用户把system.dmp导入数据库.
sunyard只是一个普通的.用户的话需要什么条件呢?
一下是出现的情况:
Import: Release 10.1.0.2.0 - Production on 星期三 11月 19 20:10:10 2008Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc
tion
With the Partitioning, OLAP and Data Mining optionsExport file created by EXPORT:V10.02.01 via conventional path
IMP-00013: only a DBA can import a file exported by another DBA
IMP-00000: Import terminated unsuccessfully
sunyard只是一个普通的.用户的话需要什么条件呢?
一下是出现的情况:
Import: Release 10.1.0.2.0 - Production on 星期三 11月 19 20:10:10 2008Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc
tion
With the Partitioning, OLAP and Data Mining optionsExport file created by EXPORT:V10.02.01 via conventional path
IMP-00013: only a DBA can import a file exported by another DBA
IMP-00000: Import terminated unsuccessfully
exp cdfs/7226631 file='/oradata/cdfs.dmp' owner=cdfs 2.在备份机器上建立相关用户,表空间,赋予相应权限
用oem建立相关的用户,表空间,做赋予权限工作
如果是全库,要给用户赋予
exp_full_database
import_full_database这样,用户在做全库备份还原的时候才不会出错。3.在备份机器上做import操作
imp userid=cdfsxt/cdfsxt@cdcz02 fromuser=cdfsxt touser=cdfsxt file='/oradata/cdfsxt.dmp'
全库备份的话,敲这个命令
imp userid=cdfsxt/cdfsxt@cdcz02 full=y file='/oradata/cdfsxt.dmp'