Wednesday, March 26, 2014

What are nodeapps in an Oracle RAC environment?

›
Nodeapps are a standard set of Oracle application services that are automatically launched for RAC (Real Application Cluster). The following...

How to use the dbms_metadata package to generate DDL for a user

›
-- Arg #1 schema name -- Arg #2 DB Directory whenever sqlerror exit 1 whenever oserror exit 2 set long 100000 verify off feedback off accep...

How to use the dbms_metadata package to generate DDL for table

›
accept table_name prompt 'Table name: ' accept owner prompt 'Table owner: ' set long 90000 set longchunksize 300 set pagesi...
Tuesday, March 25, 2014

How to perform a clone from active database

›
With Oracle 11g, a new method to clone databases was introduced: "Clone from Active Database". This method allows for cloning of...
Friday, March 21, 2014

How to set up ssh connection between two servers for user oracle

›
How to set up ssh connection between two servers for user oracle 1. connect to the remote system as user oracle 2. rm -rf $HOME/.ssh 3. ...
Tuesday, March 18, 2014

What is the difference between "in line" and "out of line" constraints?

›
The following examples create an "in line" constraint, since they both declare a constraint in the columns' definitions : C...

How to use the different options for DATE datatype in Oracle

›
Datatypes that support dates and times come in two flavours: Datetime data types , which are DATE, TIMESTAMP, TIMESTAMP WITH TIME ZONE, a...