ORA-01586: database must be mounted EXCLUSIVE and not open for this operation

Hi, I got ” ORA-01586: database must be mounted EXCLUSIVE and not open for this operation ” error during drop

 3 views last month,  1 views today

Read more

ORA-02327: cannot create index on expression with datatype LOB | Move Lob Objects to New Tablespace using dba_lobs and dba_lob_partitions views

Hi, I got ” ORA-02327: cannot create index on expression with datatype LOB ” error during table or partition moving.

 9 views last month,  5 views today

Read more

Constraints ( Primary Key, Foreign Key , Unique Key, Not Null and Check ) in Oracle SQL | Oracle SQL Tutorials -30

Hi, I will explain Constraints ( Primary Key, Foreign Key , Unique Key, Not Null and Check ) in Oracle

 7 views last month,  2 views today

Read more

ORA-19566: exceeded limit of 0 corrupt blocks for file during RMAN Backup

Hi, Sometimes You can get ” ORA-19566: exceeded limit of 0 corrupt blocks for file  error ” during RMAN Backup

 36 views last month

Read more

Alter Table and Alter Table Add or Drop Column in Oracle SQL | Oracle SQL Tutorials -29

Hi, I will explain Alter Table and Alter Table Add or Drop Column in Oracle SQL in this post of

 58 views last month

Read more