Tagged: oracle

November 28, 2014

How to grant access to all tables in a schema

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...

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...

December 13, 2013

We used to get a lot of csv files to upload to QA database as well as production DB’s. It...

December 3, 2013

Below are few points on how to manage the password policies and how to fix certain administrative tasks easily. Before...

November 28, 2013

Do the following to shrink space and re-adjust the high-water mark for a table: 1. Enable row movement for the...