How to solve ORA-25188: Cannot drop/disable/defer the primary key constraint for index-organized tables or sorted hash cluster

20 Feb

This time I was trying to reproduce an specific scenario and all of a sudden I was getting ORA-25188 in Tomcat’s console. A quick search on google revealed this method:  Connect as sysdba C:Userszulu>sqlplus / as sysdba Run the command, wait for the confirmation message SQL> PURGE DBA_RECYCLEBIN; DBA Recyclebin purged. That’s it, at least for me it worked but …

How to open computer management window from cmd in Windows 7?

13 Feb

A few days ago I needed to connect an external hard drive with a weird partition to my computer to format it as NTFS. I right clicked Computer and click Manage and nothing happened. I really don’t know why and I didn’t even care about solving it. The work around for this is to run the executable file directly from …

How to solve ORA-01017: Invalid username/password; logon denied

12 Feb

I was trying to connect to a database today when I found this: I think there could be a lot of reasons for this, but the easiest approach is to reset the user’s password, that is if the user exists of course. Here is the solution: Connect as sysdba to the database C:Usershecperez>sqlplus / as sysdba Run the following query …

How to check Oracle database version?

12 Feb

So today I needed to check what was my Oracle version because the PARTITION is not working and as far as I understand my version is not compatible with it. Here’s how to do it. Log in as sysdba C:Usersrecon1>sqlplus / as sysdba Run the following query SQL> select * from v$version; BANNER ——————————————————————————– Oracle Database 11g Express Edition Release …