Link to home
Start Free TrialLog in
Avatar of dodgerfan
dodgerfanFlag for United States of America

asked on

Host credentials and incorrect password

I have an Oracle database (version 10g) sitting on one computer. I need to get the schema I built (about 200 tables) on to 3 different servers. Each server is running Windows Server 2003 and Active Directory. I have successfully exported the database to a dump file via the Oracle Data Pump from the original computer. The problem is that when I try to import the file on one of the servers, I get as far as enetering the host credentials and it gives me an error, "Wrong password for user". I know its the right password. I've tried to give the "Log on as Batch Job" approach. It's not working. I'm wondering if it has something to do with Active Directory. I'm running around in circles trying to fix this. Any help would be appreciated.
Avatar of joebednarz
joebednarz
Flag of United States of America image

Assume by the text of your question, you are using dbconsole or GridControl to try and do this?  Why not just go to the command prompt (DOS Prompt for us old guys :-) )... then run the import?
C:\> imp userid=system@targetDB FROMUSER=original_schema TOUSER=target_schema IGNORE=Y FILE=your_export.dmp LOG=your_export_output.log
ASKER CERTIFIED SOLUTION
Avatar of sonicefu
sonicefu
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial