exporting a user without password in connection parameter??

[madhugp]

hi,

I want to export using exp command from oracle 9i .
I want to export a perticular user.

e.g exp system/system owner = scott file = c:\myfile.dmp

here i dont want to give password in export commnad.so that
we can make it confidential.
how to achive this? plz suggest.

by madhu

[vnktummala]

you can use par file or if you are not giving password it will ask you for the password (manual intervention).

Regards,

[madhugp]

hi, thanks for you reply.
Actually my requirement is I want to do the automatic exporting by making it a batch file.
In that batch file i dont want to mention any password
any where. How to ahieve this? I heard we can do this
using '/' dba. If you know the syntax plz give.

with thanks

madhu

[vnktummala]

yes you can. some thing like below ...

exp '\"/ as sysdba\"'

you need to do some R&D depends on your Oracle version.

Regards,

[LKBrwn_DBA]

...Etc ...
In that batch file i dont want to mention any password
any where. How to ahieve this? I heard we can do this
using '/' dba. If you know the syntax plz give.

Here is sample script:

DROP USER "OPS$ORACLE" CASCADE;
CREATE USER "OPS$ORACLE"
  IDENTIFIED EXTERNALLY
  DEFAULT TABLESPACE USERS
  TEMPORARY TABLESPACE TEMP
  PROFILE DEFAULT
  ACCOUNT UNLOCK;

  GRANT DBA TO "OPS$ORACLE";
  ALTER USER "OPS$ORACLE" DEFAULT ROLE ALL;

[BeefStu]

Once you have your OPS$oracle login created as per lkbrown
last post you can than do something like this as that user or from it's
crontab.

exp / options.......