Need help with exp and imp command syntax and are dmps valid backups?
Posted on 2006-06-16
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?