The ORA-01000 error indicates that the maximum number of open cursors allowed in the database session has been exceeded. This is controlled by the OPEN_CURSORS initialization parameter, which sets the maximum number of cursors (pointers to SQL statements) a session can have open at once. Identify Open Cursors: You can use the following query to … Read more
Oracle Database automatically locks a resource on behalf of a transaction to prevent other transactions from doing something that requires exclusive access to the same resource. The database automatically acquires different types of locks at different levels of Restrictiveness depending on the resource and the operation being performed. Lock Description DML Locks Protect data. For … Read more
Character Data Types: • CHAR Data Type • VARCHAR2 Data Type • VARCHAR Data Type • NUMBER Data Type CHAR Data Type The CHAR data type specifies a fixed-length character string in the database character set. You specify the database character set when you create your database. When you create a table with a CHAR … Read more
To check the total, active, and inactive sessions in an Oracle database, you can query the V$SESSION view. Checking Total Sessions To get the total number of sessions: Checking Active Sessions Active sessions are those that are currently executing SQL commands. To find the number of active sessions: Checking Inactive Sessions Inactive sessions are those … Read more
Adding partitions 11g/12c Dropping partition 11g/12c Truncate partitions Merge partition Make a partition ready only (12CR2) Split partition online (12cR2 only) Non-partition to partition Rename a partition Get row_count of partitions of a table Find the table partition keys Move partition to new tablespace
PROBLEM : The attempt to create a password file for a 12.2 database failed : SOLUTION: To address this issue, there are two options available: either provide a password that meets the complexity requirements, such as: Alternatively, you can create the password file in the 12.1 format, which differs from the default 12.2 format. Reference: