How to Modify Primary Key
Modify Primary Key Sometimes, developers may design a better primary key to support the uniqueness of a table and they want to replace the current… Read More »How to Modify Primary Key
How to Drop Primary Key
Drop Primary Key Primary key is sort of a constraint rather than an index, you should treat it as a constraint first so as to… Read More »How to Drop Primary Key
How to Add Primary Key
Add Primary Key There're 3 basic ways to create a primary key for a table. 1. System-Generated Name You don't have to provide a name… Read More »How to Add Primary Key
How to Check Primary Key of a Table
For getting the information of a primary key, we have to join two dictionary views, one is ALL_CONS_COLUMNS, the other is ALL_CONSTRAINTS. And then we… Read More »How to Check Primary Key of a Table
How to Resolve ORA-01152: file 1 was not restored from a sufficiently old backup
When I tried to open the standby database to READ ONLY for later real-time query of Active Data Guard (ADG), I got this error message.… Read More »How to Resolve ORA-01152: file 1 was not restored from a sufficiently old backup
How to Resolve SRVCTL Error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory
error while loading shared libraries After installing Oracle 10g RAC, we checked the configuration of the cluster database like this: [oracle@primary01 ~]$ srvctl config database… Read More »How to Resolve SRVCTL Error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory
How to Configure iSCSI Disk on Solaris
For Linux database servers, you may check: How to Build 18c RAC - 1 of 4 - Preparing Two Database Servers. First of all, let's… Read More »How to Configure iSCSI Disk on Solaris
How to Resolve ORA-01722: invalid number
ORA-01722 ORA-01722 means that the arithmetic operation in the statement failed to calculate because one of operands cannot be converted to a valid number implicitly.… Read More »How to Resolve ORA-01722: invalid number
How to Resolve ORA-01017: invalid username/password; logon denied
ORA-01017 ORA-01017 means that you either provided an incorrect username or password, so the database that you tried to connect denied you to logon. SQL>… Read More »How to Resolve ORA-01017: invalid username/password; logon denied
How to Resolve ORA-01000: maximum open cursors exceeded
ORA-01000 Saw an error ORA-01000: maximum open cursors exceeded when executing a lot of statements. It seemed that the number of open cursors has reached… Read More »How to Resolve ORA-01000: maximum open cursors exceeded