1 min read
The ORA-01000 error indicates that the maximum number of open cursors allowed in the database session has been exceeded. This...
Month: June 2022
1 min read
4 min read
Oracle Database automatically locks a resource on behalf of a transaction to prevent other transactions from doing something that requires...
4 min read
Character Data Types: • CHAR Data Type • VARCHAR2 Data Type • VARCHAR Data Type • NUMBER Data Type CHAR...
2 min read
To check the total, active, and inactive sessions in an Oracle database, you can query the V$SESSION view. Checking Total...
Adding partitions 11g/12c -- SYNTAX : ALTER TABLE <SCHEMA_NAME>.<TABLE_NAME> ADD PARTITION <PARTITION_NAME> VALUES LESS THAN < HIGH_VALUE> TABLESPACE <TABLESPACE_NAME >...
1 min read
PROBLEM : The attempt to create a password file for a 12.2 database failed : $ orapwd file=$ORACLE_HOME/dbs/orapwprod101 password=oracle OPW-00029:...
