<div>
<div class="content wysiwyg-content">
<br />
I take a dump of the database every 6 hours. &nbsp;Each dump gets a different name. &nbsp;Next day's dumps overwrite the previous day's dmps.<br />
<br />
Here is the syntax I use in a bat file<br />
exp Bubba/password@database File=D:\database\Export\22<wbr />00.dmp LOG=D:\database\Export\220<wbr />0.log OWNER=User<br />
<br />
Do I need to login &quot;as sysdba&quot; to do the export. &nbsp;Export using the line above works fine.<br />
<br />
Maybe the more relevant question is what imp command do I need? &nbsp;<br />
<br />
IMP system/system@MBA FROMUSER=Bubba TOUSER=Brent FILE=D:\Database\Export\22<wbr />00.dmp LOG=IMP_MBA.LOG<br />
<br />
Are there any requirements for the FROMUSER or the TOUSER in relation to the Owner parameter I used in the export? &nbsp;Do I need to login &quot;as sysdba&quot; to do the import. &nbsp;Does it matter which user name I log in as into the target db.<br />
<br />
It takes a couple of minutes for the export to run. &nbsp;During that time the db is available, and it is possible for a process to occur that updates multiple tables. &nbsp;Transaction updates Table A &amp;&nbsp;Table B. &nbsp;If the export process has already exported table A when the transaction occurs, will Table B still be updated eventhough Table A isn't?
</div>
</div>



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?

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

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.