NLS_DATE_FORMAT is a parameter heavily dependent on a session. A good practice is to write a logon trigger depending on the application…
Tag oracle
— Make Table Read Only [sourcecode language=”sql”] alter table <table_name> read only; [/sourcecode] — Make Table Back to Read Write.…
After years of working with Oracle database. There is an intriguing question which came in my mind today after doing…
This is a script to create a logon trigger for blocking third party tools like Toad, SQl Navigator etc from…
This error generally occurs when you are trying to trace a user session using the DBMS_SUPPORT package. But this package isn’t…
— Insert statements dynamically — Select ‘insert into abc values(‘||col1||’,’||col2||’,’||col3||’,’||col4||’);’ from xyz;
Oracle allows the database to access a flat file as a table. You can have a flat file with a…
Shell Script to generate a column seperator report in SQL*PLUS using a shell script. It can be opened in Excel…
This is a script to query a table, generate the result in HTML and send an email using mailx for…
CREATE TABLE REPLICATION USING MATERIALIZED VIEWS ————————————————- SOURCE TABLE : LOG_RECORD TARGET TABLE : LOG_RECORD_UPD We have a large table…
Query to find out size of the 10 Largest Tables sitting inside an Oracle database which is greater than 1GB…
Suppose you have a query result and want to concatenate a string to that output for better readibility, it can…
Sometimes it is required to find the largest tables residing in your database. It helps to identify candidates for table…
SQL Query to check size of Table — Check Size in GB SELECT bytes/1024/1024/1024 FROM USER_SEGMENTS WHERE SEGMENT_NAME in (‘TABLE1′,’TABLE2’);…
We will create 2 standby databases from a single RAC primary database. 11gR2 allows upto 30 standby databases. The most…
One of the best books I have read on Oracle database security.It skips all the basics like what is a…
Do a “create table” as command without selecting any rows create table abc_new as select * from abc where 1=0;
Original Article on http://www.orafaq.com/node/2756 by Micheal Rajendran Introduction Oracle has leap forwarded the middleware technologies especially the database technology into the cloud.…
Primary is a 2 node-rac cluster with instances swx1 and swx2 running on ASM. A service called swxscan is created…
We had a new Oracle installation on an AIX 6.1 Power7 server. Our organization doesn’t have an AIX admin. So…
To Configure RAC 11gR2 on AIX 6.1 using ASM. You need to prepare the raw devices like below. The general…
bash-3.2$ impdp system/***** directory=import_dir nologfile=y dumpfile=exp_swx_20092012.dmp full=y ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-31640: unable to open…
The various security mandates these days required a lot of auditing on the database. Though there are a host of…
Occasionally you need to create a quick one node RAC setup for testing and one of the requirements is a…