Search This Blog

Monday, July 11, 2011

How to change an Oracle Database password temporarily.

Lets unlock the hr user and give it a password.
SQL> alter user hr identified by hr account unlock;

User altered.

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.