霍钧城吧 关注:6贴子:150
  • 0回复贴,共1

oracle还原dmp

只看楼主收藏回复

oracle数据库密码:orcl
创建账号:CREATE USER vdrs IDENTIFIED BY manager DEFAULT TABLESPACE   USERS TEMPORARY TABLESPACE TEMP;
授权:grant connect,resource,dba to vdrs
CREATE SMALLFILE TABLESPACE vdrs DATAFILE 'F:\ORADATA\ORCL\vdsr.DBF'
SIZE 100M
AUTOEXTEND ON NEXT 100M
MAXSIZE UNLIMITED
LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW ,
    DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,
       DBA,CONNECT,RESOURCE,CREATE SESSION   TO vdrs
命令提示符窗口下执行:imp vdrs/manager@orcl full=y file=d:\vdrs.dmp ignore=y log=e:\log.txt



1楼2011-06-08 17:01回复