Nothing but my learning and experience with Oracle..!

Pages

▼
Thursday, October 5, 2017

Can we flashback a table dropped by sys user ?

›
It depends on the ownership of the table that being dropped by sys. If SYS user dropped a table that has been owned by some other user, ...
1 comment:
Friday, September 29, 2017

Col backup without redo log files and tempfiles - Is it really required to include redo and temp files in cold backup ?

›
Since temporary tablespaces don't hold any objects and are created in seconds, there's no reason to back them up. What about redo ...
Saturday, September 23, 2017

Database recovery from the loss of all database file - datafiles, controlfiles , redologfiles ,archivelog files and spfile

›
Before deleting the entire database files for simulating the scenario I ensured I have a full database backup which I took some time back....
‹
›
Home
View web version
Powered by Blogger.