ORACLE

  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 …

The Oracle password file is a file that is created automatically during installation. Users defined in this file can connect to oracle via sqlplus without …

Tablespaces are areas dedicated to storing objects in the database. Tablespaces are logical constructs. However, it contains physical data files or temp files. There are …

  User and schema creation operations are the same in Oracle. When you create a user, a schema is automatically created for the user. Each …

  As the Oracle database grows, the existing data files in the tablespace will fill up. In such a case, you will need to add …

  In this article, I will tell you how to connect to RMAN. We are doing ssh with server as root user. You can use …

  To connect to Oracle with sqplus you need to load the environment. You need to use the .oraenv or .profile file to load the …