ORA-14452

ORA-14452: attempt to create, alter or drop an index on temporary table already in use

Sometimes, we face ORA-14452 during drop or alter. SO, in this article, we are going to learn how to solve “ORA-14452: attempt to create” this error. We face this issue if the table is currently used in any other session, and we trying to drop or alter the table. Find …

Read moreORA-14452: attempt to create, alter or drop an index on temporary table already in use

Global Temporary Tables

Global Temporary Tables

Applications regularly utilize some type of impermanent information store for processes that are too convoluted to finish in a solitary pass. Regularly, these transitory stores are characterized as data set tables or PL/SQL tables. From Oracle 8i ahead, the upkeep and the board of transitory tables can be assigned to …

Read moreGlobal Temporary Tables

RMAN BACKUP SCRIPT

RMAN BACKUP SCRIPT

How to automate Oracle RMAN Backup with shell script In a real environment, you obviously won’t manually trigger all of the Oracle database backups. An automated mechanism is required to enable RMAN backups. In this article, we’ll look at automating RMAN backup using a shell script. Create Backup Location On …

Read moreRMAN BACKUP SCRIPT

Enable Notifications    OK No thanks