This content has been marked as final. Show 4 replies
A toad forum would likely give a better answer. But anyways, have you tried with the 9i sqlplus? There is a compatibility matrix on MOS Client / Server / Interoperability Support Between Different Oracle Versions [ID 207303.1] which says to go from 9i to 11g you must be on 22.214.171.124 or later. Anything below that not supported.
Edit: Also, 11 has case sensitive passwords, maybe toad is sending all uppercase or the converse.
Edit2: invalid username/password
Edited by: jgarry on Feb 9, 2012 10:18 AM
Edited by: jgarry on Feb 9, 2012 10:20 AM
the message that username/password is incorrect: ORA-01017: invalid username/password; logon denied.
But I think I recall that Toad (older versions) has some password "feature" that does not work well with case sensitivity in passwords introduced in current release.
Search at toadworld or get a current toad.
Can any one advise me how to export the Update statement from toad or any other tool.(Here having a big number of record that have export from instance and run as a script in the another instance so that the all records will update at once)
In toad, we can export the insert statement from export data option.
similarly can we export the update query from toad or any other tool or have any procedure that generates the update statement.
Thanks a lot,