Need help with exp and imp command syntax and are dmps valid backups?


I take a dump of the database every 6 hours.  Each dump gets a different name.  Next day's dumps overwrite the previous day's dmps.

Here is the syntax I use in a bat file
exp Bubba/password@database File=D:\database\Export\2200.dmp LOG=D:\database\Export\2200.log OWNER=User

Do I need to login "as sysdba" to do the export.  Export using the line above works fine.

Maybe the more relevant question is what imp command do I need?  

IMP system/system@MBA FROMUSER=Bubba TOUSER=Brent FILE=D:\Database\Export\2200.dmp LOG=IMP_MBA.LOG

Are there any requirements for the FROMUSER or the TOUSER in relation to the Owner parameter I used in the export?  Do I need to login "as sysdba" to do the import.  Does it matter which user name I log in as into the target db.

It takes a couple of minutes for the export to run.  During that time the db is available, and it is possible for a process to occur that updates multiple tables.  Transaction updates Table A & Table B.  If the export process has already exported table A when the transaction occurs, will Table B still be updated eventhough Table A isn't?
LVL 4
averybAsked:
Who is Participating?
 
jrb1Commented:
No, you don't have to run as SYSDBA.  When importing, you'll have to have access to the schma you're importing to (the TOUSER).  Also may need to be able to create tablespaces.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.