ORACLE

  With the flashback database we can use the restore point to return the database to a time in the past. For more detailed information …

  Using the FLASHBACK database, we can return the database to a time or a SCN number in the past. You can think of FLASHBACK …

  With the logging_clause parameter, we can specify whether the database objects are to be logged in the redo log when they are created, using …

Before you read this article, I suggest you read the article “What is logging_clause On Oracle (LOGGING or NOLOGGING)” to better understand the concept of …

  For restart operation, we must stop and start the Oracle database. In this article we will show the below scenarios; stop an instance of …

  You can use Undo Advisor to set UNDO_RETENTION and the required undo tablespace size. You can open the Undo Advisor using the Database-> Diagnose-> …

  In this article, I will show you how to get a user’s create script in Oracle12c, with the hash of the password. We may …

  When the user password expires, we get the error “ORA-28001: the password has expired“. The expiration date of the user’s password is defined in …

ORA-01555 Snapshot Too Old The “ORA-01555 Snapshot Too Old” error usually comes in long-running queries. In Oracle, previous changes of the data are retained in …

  To run the database in automatic undo management mode, you must set undo_management to auto from the oracle startup parameters.   You can use …