Category: Oracle Database

March 11, 2015

Expdp shell script example Oracle DB

When migrating or creating a backup of oracle database schema we usually use the expdp tool to export oracle database...

February 24, 2015

Sometimes we face issues on environment related to DB during database open with the messages as “unable to open undo...

November 28, 2014

Here in this article we will discuss on how to grant access to all tables in a schema in oracle...

November 26, 2014

We had a requirement where the DB connections which are in INACTIVE state for atleast 4 hours shall be cleared...

August 27, 2014

After installing the oracle database software’s we need to create oracle database to start with our tasks. Here to achieve...

June 23, 2014

While starting or stopping Oracle database if you are getting below error for pfile or spfile you can resolve these...

April 30, 2014

Below are few useful queries to debug issues with TEMP tablespace. These queries are collected from different sources and put...

April 30, 2014

Temporary tablespaces are used to manage space for database sort operations and for storing global temporary tables. Sometimes the TEMP...

February 25, 2014

While importing a db dump to oracle database we usually get the “Deferred Segment Creation” error while importing. Though the...

February 24, 2014

If you are getting below ORA-23515 error while dropping a tablespace in Oracle database, then please follow below steps to...