Blog Archives

Duplicate Oracle Constraints

If you have ever used the Oracle import utility, your database has system generated constraint names (ex: SYS_C00641321), and you did not specify CONSTRAINTS=N during the import then chances are you have duplicate constraints for pretty much every constraint except

Tagged with: , , , , , , ,
Posted in Database Administration

Password Case Sensitivity in Oracle 11g

Oracle 11g now sets the password case sensitivity setting to TRUE by default. If you are running any application that connects to an earlier version of an Oracle database, chances are you are sending the connect string in all caps

Tagged with: , , , , ,
Posted in Database Administration

Error: Twitter did not respond. Please wait a few minutes and refresh this page.