There you go http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
Category Database
In this exercise we will copy a file residing on a filesystem onto ASM disk. [sourcecode language=”sql”] SQL> create or…
This error normally occurs when you are trying to import a dump file which is residing on an NFS file…
————- Drop Database Manually Oracle ——————— 1. First get the datafiles, control files and redo log files location Login to…
Suppose you need to fire a trigger based on the change of value of a column and then perform some…
NLS_DATE_FORMAT is a parameter heavily dependent on a session. A good practice is to write a logon trigger depending on the application…
— 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 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…
This error comes when running ggsci on a linux or unix platform. Generally it is due to wrong setting of…
CREATE TABLE REPLICATION USING MATERIALIZED VIEWS ————————————————- SOURCE TABLE : LOG_RECORD TARGET TABLE : LOG_RECORD_UPD We have a large table…
To select 10 random records from a table in Oracle SELECT * FROM ( SELECT * FROM TABLE_NAME ORDER BY…
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’);…
######### ERROR ##### DGM-17016: failed to retrieve status for database ORA-16664: unable to receive the result from a database DGMGRL>…
DGMGRL> show configuration Warning: ORA-16714: the value of property ArchiveLagTarget is inconsistent with the database setting Warning: ORA-16714: the value…
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…