Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a database dump file with me, I need to make two copies of the database using the same dump file in two users.

Is it possible?

share|improve this question
1  
What sort of dump file do you "have with you"? Is it created by Data Pump Export (expdp) or the old fashioned Export (exp)? –  Colin 't Hart Jan 30 '13 at 10:07
    
@colin-t-hart I have a .dmp file with me –  nigel thomas Jan 30 '13 at 10:11
    
.dmp says nothing about the format of the dump file. –  Colin 't Hart Jan 30 '13 at 14:15
    
it is solved, thank u... –  nigel thomas Jan 30 '13 at 14:30

2 Answers 2

If your dump has been created with exp then you may use imp for importing it. If you exported schema USERA and want to import these objects in schema USERB, then use command:

imp user/password@sid FROMUSER=USERA TOUSER=USERB FILE=yourfile.dmp

you may get more example of imp on the Import Export FAQ. You may import your dump two times using different USERB.

share|improve this answer
1  
impdp user/password DUMPFILE=file_name directory=dir LOGFILE=test.log REMAP_SCHEMA=USERA:USERB TABLE_EXISTS_ACTION=APPEND USER A is the existing user USER B is the new user –  nigel thomas Jan 30 '13 at 13:54

impdp user/password DUMPFILE=file_name directory=dir LOGFILE=test.log REMAP_SCHEMA=USERA:USERB TABLE_EXISTS_ACTION=APPEND

This will solve the issue.

USER A is the existing user USER B is the new user

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.