Command to take backup and restore Oracle DB

[beulajo]

Dear

I need to take backup of an oracle DB. I knew the command called exp.... to take backup in the form of dmp file

I have successfully taken backup.

I have used imp.. command to restore the db in some other place.

But the problem that i face is After restoring the db in another location. No changes are reflected there. Why??

Is it because I am trying to overwrite the existing db.. If it is so what is the command to overwrite the existing db with by current backup(dmp) file.

I don't want to drop the db for every restoring. That is what i have done recently to restore the db during deployment

Thanks is advance

[debasisdas]

no need to drop the DB , just create a new your and import to that user.

[beulajo]

@debasisdas
I do not understand. Can you still be clear and tell me how to do that

thanks

[debasisdas]

1.Create a new user
2.Grant all the required previlages
3.use FROMUSER , TOUSER in import command.