Welcome to alphageek369
Be persistent in what you do !
Latest from the Blog
SKIP DATAFILES DURING RMAN DATABASE BACKUP
I was taking backup of a database which got failed due to corrupted datafiles. Backup keep on failing for the whole database, even though one of the datafile is corrupted. After searching for the documentation to skip the particular datafile and take backup of remaining 95% of the data, i was able to get some … Continue reading “SKIP DATAFILES DURING RMAN DATABASE BACKUP”
CAN WE GRANT ACCESS TO MULTIPLE TABLES AT A TIME IN ORACLE?
The answer is NO 1)Workaround can be to use the script to generate multiple grant statements 2)Use ROLES as a standard way
TRUNCATE TABLE HANG OR SLOW ORACLE
Truncating a table is faster compared to delete statement in a database. But if the truncate itself is slow, then what may be the cause for the slowness? If flashback archive is enabled for a table which needs to be truncated. In this case, additional overhead is needed to mimic the data which need to … Continue reading “TRUNCATE TABLE HANG OR SLOW ORACLE”
StAxAlPhA 