I do a lot of Oracle imports/exports everyday using Sqoop with good success. However, I keep hitting a gotcha - any time we try to import from an Oracle database that had a password with special characters we get invalid username/pw error.
If we get the password changed to something without a special character it works like a charm. Problem is we're now faced with some databases that have a special character password required so we're kinda hosed. Using --password via CLI currently. Any ideas? Sent from my iPhone
