#745
Error :
database
#739
#736
Create new TBS : Set as default undo tablespace : Retrieve the old one Drop it or :
#684
#673
For looped private synonyms, try: To find public synonyms for non existant objects which will generate the looping error as well:
#650
Disable all constraints : Enable all constraints :
#456
In development environment, it is very common scenario that we have multiple databases in a single machine by using VMware (i.e, each VMware contains one database). Again those machines doesn’t have consistant power backup. Therefore we have to face power failure or VMware hang-up. So, we are forced to restart the machine while databases are […]
#414
#406
Shutdown DB : Start mounting ; Drop all missing files (1 by 1) : Restart DB :
#360
Symptoms After Power Fail Alter database open fails with Changes Power failure Cause There was a power failure causing logical corruption in controlfile Solution Option a Query 1 Note down the name of the redo log Take a OS Level back of the controlfile (This is to ensure we have a backup of current state […]