Arvind Toorpu

Blog Posts

Purging a Database Audit Trail AUD$

March 17, 2014

Purging a Subset of Records from the Database Audit Trail You can manually remove records from the database audit trail tables. This method can be useful if you want to remove a specific subset of records. You can use this method if the database audit trail table is in any tablespace, including the SYSTEM tablespace.…
Create a sample schema with 1millions rows in Oracle

March 6, 2014

We always to test the database for various reasons we will need to create a tables with a lot of data in it.We can use below script that will allow us to create a table and populate the table with 10,00,000 rows with simple plsql block. This is just for demo purpose and have been…
How to Add/Drop/Rename Standby Redolog file

February 19, 2014

How to Drop/Rename Standby Redolog file in Oracle 11gWhile performing the dataguard Broker, we need to drop the standby database while switchover the standby . As it seems an easy task but it is bit tricky . Below are the steps to drop the redolog file from standby database : On Standby Database : SQL>…
Oracle Active Data Guard Or Oracle GoldenGate

February 17, 2014

Oracle Active Data Guard and Oracle GoldenGate Oracle Active Data Guard and Oracle Golden Gate are strategic capabilities within Oracle’s software portfolio. While they generally fall into the category of replication technologies, each has a very different area of focus.Oracle Active Data Guard provides the best data protection and availability for Oracle Database in the…
TOAD USER SCRIPT

February 6, 2014

SCRIPT TO CREATE TOAD USER : I really had to struggle a lot to get this script.Creating these objects as toad user will allow u to gathers stats for disk ,data file and table spaces growth and trending. This scipt need to be run as toad user to create all the tables & ddl needed…