Oracle Database

How to Install Oracle Database 12C in Centos 7 Linux

1 - Step 1 : Install Centos 7 : Give ISO location in CD-Rom Location and Boot. RAM 4 GB Partition : 60 GB. 01 - Boot Partition    :  1,000 MB. 02 - /  Root Partition : 35,000 MB. 03 - Swap              :  8,000 MB. 04 - Data              :  The Rest o…

Oracle Database : Flashback

ALTER TABLESPACE undotbs1 RETENTION GUARANTEE; ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE; Default database initialization parameters: - UNDO_MANAGEMENT='AUTO - UNDO_TABLESPACE='UNDOTBS1' - UNDO_RETENTION=900 Collect undo block info w…

Backup, Drop and Restore Database step by step.

set oracle_sid=ORCL SET ORACLE_UNQNAME=ORCL Go to RMAN sqlplus /nolog conn / as sysdba ---- Get the Oracle DBID select DBID from v$database; 1033682200 ----- Giving folder permissions. # chown -R oracle:oinstall /data/backup # chmod -R 775 /data/backu…

Oracle Database-Oracle Data Migration from 11g to 10g

C:\oracle\product\10.2.0\db_1\bin\exp.exe hr/hr@orcl file=C:\Users\Administrator\Desktop\bk\hr10g.dmp full=n C:\oraclexe\app\oracle\product\11.2.0\server\bin\exp.exe hr/hr@xe file=C:\Users\Administrator\Desktop\bk\hr11g.dmp full=n STATISTICS= -…

DML in Access DB by Oracle RDBMS (Oracle 10g in Windows 2003)

VIEW DATA FROM MICROSOFT ACCESS 2003 AT ORACLE 10G RELEASE 1 (WIN 2003) : STEP 1: CREATE A MICROSOFT ACCESS TABLE : my_access_tab STEP 2: CREATE AN ODBC LOCAL SYSTEM DSN AND SELECT ACCESS *.MDB FILE PREVIOUSLY CREATED AND GIVE USER NAME AND PASSWORD I…

How to make Oracle Database Archivelog

follow the below steps: step1 :shutdown immediate step2: edit the pfile with the following log_archive_start=true log_archive_dest_1=’location=d:\archive_loc’ step3:startup mount step4:alter database archivelog step5: alter database ope…

Load More
That is All