I'm trying to utilize the EXPDP procedure, but the password for the user I need to export with has a hash in the password. I've tried several variations on the command, but none of them seem to work. This particular database is residing on an AIX 6.1.
The commands I've tried are:
expdp 'user/p#assword@server' estimate_only
expdp 'user'/'p#assword'@'server' estimate_only
expdp 'user/p#assword'@server estimate_only
expdp 'user/p#assword'@'server' estimate_only
expdp 'user/p#assword@server as sys' estimate only
As well as the same permutations with quotation marks.
The error I get is "LRM-00108: invalid positional parameter value."
I've seen a solution that involves making a script that has this command where the password is saved as a separate file and invoked with a cat, but I'd prefer to not have a plaintext password hanging out on the server if thats at all possible to avoid...