<div>
can you try this. Your command does not have the username/password supplied.<br />
<br />
exp sys/sysdb@testdb owner=scott file=/tmp/tems_adm_orig.dm<wbr />p indexes=y constraints=y rows=n log=/tmp/tems_adm_orig.log<wbr /><br />
<br />
Thanks
</div>


can you try this. Your command does not have the username/password supplied.

exp sys/sysdb@testdb owner=scott file=/tmp/tems_adm_orig.dmp indexes=y constraints=y rows=n log=/tmp/tems_adm_orig.log

Thanks

<div>
I got the following errors:<br />
<br />
EXP-00056: ORACLE error 1017 encountered<br />
ORA-01017: invalid username/password; logon denied<br />
<br />
&nbsp;The sys password was correct. I can only assume it is because I didn't have the as sysdba 
</div>


I got the following errors:

EXP-00056: ORACLE error 1017 encountered
ORA-01017: invalid username/password; logon denied

 The sys password was correct. I can only assume it is because I didn't have the as sysdba

<div>
what i meant to say was use an username/password@your_dat<wbr />abase_name<wbr /> when calling the exp utility.<br />
<br />
I think you need to check with your dba or someone who can give you the correct username/password so that you can run your export.
</div>


what i meant to say was use an username/password@your_database_name when calling the exp utility.

I think you need to check with your dba or someone who can give you the correct username/password so that you can run your export.

<div>
Closed, 500 points refunded.<br />
kb<br />
Experts Exchange Moderator
</div>


Closed, 500 points refunded.
kb
Experts Exchange Moderator

<div>
<div class="content wysiwyg-content">
 I type the following to export:<br />
<br />
exp owner=tems_adm file=/tmp/tems_adm_orig.dm<wbr />p indexes=y constraints=y rows=n log=/tmp/tems_adm_orig.log<wbr /><br />
<br />
But at the end of the export I get these errors:<br />
<br />
&nbsp;EXP-00008: ORACLE error 3113 encountered<br />
ORA-03113: end-of-file on communication channel<br />
EXP-00000: Export terminated unsuccessfully<br />
<br />
<br />

</div>
</div>


 I type the following to export:

exp owner=tems_adm file=/tmp/tems_adm_orig.dmp indexes=y constraints=y rows=n log=/tmp/tems_adm_orig.log

But at the end of the export I get these errors:

 EXP-00008: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel
EXP-00000: Export terminated unsuccessfully




how do I successfully export schema

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.