Materialized View Example
ORASOA side: create table tab1(c1 char(10),c2 char(10),c3 char(10)); begin for i in 1..10000 loop insert into […]
Technology
Technology
Technology
All about table and constraints in Oracle
CREATING ORACLE DATABASE OBJECTS CREATING TEMPORARY TABLES SQL>CREATE GLOBAL TEMPORARY TABLE TEMP_EMP (EMPNO NUMBER,ENAME VARCHAR2(10)) CREATING ONE TABLE
security
DBMS_CRYPTO example
SQL> CONN SYS/SYS AS SYSDBA Connected. SQL> set serveroutput on SQL> SQL> set linesize 121 SQL> SQL> DECLARE l_credit_card_no VARCHAR2(19)
Dataguard
FAST START FAILOVER (FSFO) CONFIGURATION USING FAR SYNC NODE AS OBSERVER IN DATAGUARD USING DGMGRL
FAST START FAILOVER (FSFO) CONFIGURATION USING FAR SYNC NODE AS OBSERVER IN DATAGUARD USING DGMGRL 1.For data guard DGMGRL
Dataguard
Step by Step Oracle Active Data Guard Far Sync RAC
Step by Step Oracle Active Data Guard Far Sync RAC Active Data Guard Far Sync, a new capability with
Dataguard, SCRIPTS
Script to sync check of applied archive log between 2 RAC databases
1.First create the shell script mentioning all environmental variables adjusted to your environment. vi dataguard_dr_sync_check.sh #!/bin/bash cd /u01/app/oracle/shells for k
Backup and Recovery
RMAN incremental Backup cumulative and differential
RMAN Incremental backup This backups only datafile blocks changed since specified previous backup. 1.This strategy could be followed to make
ASM
ASM overview and commands
Automatic Storage Management (ASM) A.Overview of Automatic Storage Management (ASM) Automatic Storage Management (ASM) simplifies administration of Oracle related
Installation
Basic oracle database creation and maintenance in windows and Linux
DB CREATION STEPS IN WINDOWS SETTING AN ENVIRONMENT(FOR WINDOWS) ORADIM -new -sid <new_sid> -intpwd oracle -startmode AUTO -pfile c:\oracle\admin\<new_sid>\pfile\init<new_sid>.ora
security
Oracle users,roles,audit and security
MANAGING SECURITY Managing Profiles 1.Creating profile and Granting it to user CONN sys/password AS SYSDBA CREATE PROFILE my_profile LIMIT