Posted by Mir Sayeed Hassan on 26th January 2020
ORA-00054: resource busy and acquire with NOWAIT specified Error occur while creating a table. SQL> create table MIR.T_TRANSACTION(C_ID VARCHAR2(255 CHAR) not null primary key); ORA-00054: resource busy and acquire with NOWAIT specified ORA-00054: resource busy and acquire with NOWAIT specified 9260 views Less than… Read more..
Posted in ORA-Error | Comments Off on ORA-00054: resource busy and acquire with NOWAIT specified
Posted by Mir Sayeed Hassan on 4th January 2020
How to Enable & Disable flashback in Oracle database 11gR2(11.2.0.4.0) Flashback in Oracle Database It’s a technology in Oracle database to perform restore the database to a particular point in past. In case if you have lost the data like DML & want to retrieve, you can retrieve the rollback operation through flashback without using… Read More
Posted in Flashback | Comments Off on How to Enable & Disable flashback in Oracle database 11gR2(11.2.0.4.0)
Posted by Mir Sayeed Hassan on 1st January 2020
ORA-01552: cannot use system rollback segment for non-system tablespace ‘TEMP_NEW’ I faced the above error while creating the explain plan for one of the table in database as shown below Create an explain plan for analysing to create an index duration & size SQL> explain plan for create index idx_tpay_recon_C_OCCURDATE… Read more..
Posted in ORA-Error | Comments Off on ORA-01552: cannot use system rollback segment for non-system tablespace ‘TEMP_NEW’
