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 […]
CREATING ORACLE DATABASE OBJECTS CREATING TEMPORARY TABLES SQL>CREATE GLOBAL TEMPORARY TABLE TEMP_EMP (EMPNO NUMBER,ENAME VARCHAR2(10)) CREATING ONE TABLE […]
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)
FAST START FAILOVER (FSFO) CONFIGURATION USING FAR SYNC NODE AS OBSERVER IN DATAGUARD USING DGMGRL 1.For data guard DGMGRL
Step by Step Oracle Active Data Guard Far Sync RAC Active Data Guard Far Sync, a new capability with
#!/bin/bash . /home/oracle/.bash_profile export log=/u01/app/oracle/shells/clean_rdbms_audit.log echo $ORACLE_HOME | tee $log echo “DELETING AUDIT LOGS FROM RDBMS” | tee -a $log
This script will show tablespaces from all databases in server which are full by 85 percent.This script will take care
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
RMAN Incremental backup This backups only datafile blocks changed since specified previous backup. 1.This strategy could be followed to make
Automatic Storage Management (ASM) A.Overview of Automatic Storage Management (ASM) Automatic Storage Management (ASM) simplifies administration of Oracle related
DIRECTORY STRUCTURE IN UNIX Directory Contains bin/ Required Boot-time binaries boot/ Boot configuration files for the OS loader and kernel