I'm trying to repair a the undo tablespace file which is stopping the database from opening. However the file that it needs arc00040.001 is not present the closet one there is is arc00006.001 but it is nearly 3 months old. As they are not too fussy about time is there any way that I can use this file instead or start the database up by creating a new undo tablespace.
In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.