Another EXPORT problem

[fmorel]

I try to use export in a batch (Windows)

It works well, but my batch is not perfect:
if the password for the user (schema) I use for export changes, then export utility asks (interactive mode) to reenter login/password, and my batch is stucked forever.

Example:
My batch does the following:

J:\>exp scott/deadtiger@mdb file=test.dmp

Export: Release 8.1.7.0.0 - Production on Fri Oct 25 15:23:34 2002

(c) Copyright 2000 Oracle Corporation. All rights reserved.


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

---> Exp waits for the batch to reenter Username, and then nothing happens...

So, is there a way to avoid exp to enter interactive mode? ie: if there's an error, it returns the error code and that's it.

Thanks for answers
Regards

 

[dmooreora]

You can try this:

J:\>exp system/manager@mdb file=test.dmp owner=scott

If you do not change the system password often.

Dmooreora.

Also, look into using SQL*LOADER. It is good for batch loading and unloading of data.

 

[fmorel]

Thanks for answer

In this case, my aim is not to load or unload data, but to keep a "snapshot" of my whole schema for archiving needs.

I do not want to use system user, because the password may be seen in the batch. I only need a user with connect and exp_full_database role.

Finally, the solution will be to always keep the same password !

 

[sem]

You may "hide" logon details in parfile.