Import Oracle 11gR2 backup (specific users) to Oracle 10gR2
1. Export full database backup
exp
2. Drop specific user which need to import
DROP USER ATMUTL CASCADE;
DROP USER BACH CASCADE;
DROP USER BACHINT CASCADE;
DROP USER BNSUSER CASCADE;
DROP USER FIUINT CASCADE;
DROP USER ISLBAS CASCADE;
DROP USER ISLIMG CASCADE;
DROP USER ISLITS CASCADE;
DROP USER ISLSYS CASCADE;
DROP USER MYBANK CASCADE;
DROP USER ORBBBR CASCADE;
DROP USER ORBITS CASCADE;
DROP USER SBLMIS CASCADE;
DROP USER SMSGTWAY CASCADE;
DROP USER STFOREX CASCADE;
DROP USER STLBAS CASCADE;
DROP USER STLIMG CASCADE;
DROP USER STLSYS CASCADE;
DROP USER WEBADMIN CASCADE;
3. Unrar backup rar file
unrar e Stelar_31102013.rar
4. Import specific database users
imp user/passwd file=/back/export_backup/Stelar_Thu.DMP fromuser=MYBANK,STLSYS,ORBITS,BACH,BACHINT,ORBBBR,FIUINT,ISLBAS,SMSGTWAY,ISLITS,ISLIMG,WEBADMIN,BNSUSER,STLBAS,ATMUTL,STLIMG,STFOREX,ISLSYS,SBLMIS touser=MYBANK,STLSYS,ORBITS,BACH,BACHINT,ORBBBR,FIUINT,ISLBAS,SMSGTWAY,ISLITS,ISLIMG,WEBADMIN,BNSUSER,STLBAS,ATMUTL,STLIMG,STFOREX,ISLSYS,SBLMIS
Does it requird "version" keyword ?
ReplyDeleteThanks Utpal da for your question...
DeleteActually i have tested the above steps in my lab and its work fine for me..