Lets unlock the hr user and give it a password.
SQL> alter user hr identified by hr account unlock; User altered.
Monday, July 11, 2011
Undo tablespace recovery in case of no backups.
This method to recover Undo tablespace is not a substitute for recovery procedures
through backups as mentioned in the official Oracle documentation.
But if you get stuck in a situation where you don’t have any backups and need to
recover your Undo tablespace , then use this method as a last resort.
through backups as mentioned in the official Oracle documentation.
But if you get stuck in a situation where you don’t have any backups and need to
recover your Undo tablespace , then use this method as a last resort.
Subscribe to:
Comments (Atom)