Dear Readers, In this article we will see How to install Oracle software and creation of database. on RAC Environment . Please check the below link : How to install Oracle software on RAC Environment To Install Oracle software we need download Oracle binaries for… Read More
Dear Readers, In this article we will see How to Installing Cluster software Please check the video link : Install Cluster software To install cluster software we required to download Grid infrastructure binaries from OTN Otherwise check below link for download software https://drive.google.com/open?id=1tyr0aQzipiUUllOajDf4I-TgNI2B3lfA Login with Oracle… Read More
Dear Readers, In this article we will see How to clone a virtual machine and setting up eth0 and eth1 files.. Please check the video link : How to clone Virtual machine Cloning from RAC1 to RAC2 :- Copy all files from RAC1 folder to RAC2… Read More
Dear Readers, In this article we will see How to setup N/W , Pre-requisites RPM’s ,directories and how to add shared storage. Please check the video link : Setting Up Network iP’s To setup IP Addresses Goto preferences–> Network Authentication It will pop-up following terminal Select… Read More
Dear Readers, In this article, we will see Installing OEL Operating System on Virtual machine and installing Vmware tools. Please check the video link : To install Oracle Enterprise Linux on Virtual machine , we need to download OEL operating ISO image file from Oracle.com In… Read More
Dear Readers, In this article we will see how to install Two Node RAC installation on VM ware workstation. Entire two node RAC installation i have categorized into 6 parts. PART-1 Installing VMWARE WORKSTATION on WINDOWS and Creating Virtual machine ORACLE TWO NODE RAC INSTALLATION… Read More
SSH Connectivity between two nodes (Manual) In this article we will see how to make SSH connection manually between two nodes. Node Details : Node1 : RAC1 Node2 : RAC2 Follow below steps to setup SSH In Node1 (RAC1) : Create directory called .ssh… Read More
Implementing Interval Partition with Enable Row Movement In this article , we will learn how to implement interval partition with enable row movement. Table Creation with interval partition (without interval Row Movement. Create user
|
1 2 3 |
SYS>>grant dba to ajay identified by ajay; Grant succeeded. |
Now create table with interval partition.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 |
SYS>>CREATE TABLE AJAY.MIC_INS_DD ( ID VARCHAR2(32 CHAR) NOT NULL, NAME VARCHAR2(35 CHAR) NOT NULL, KEY VARCHAR2(30 CHAR) NOT NULL, MIC_TAG_ID DATE default (to_date('01-01-1999', 'MM-DD-YYYY')) ) TABLESPACE MIC_DATA RESULT_CACHE (MODE DEFAULT) PCTUSED 0 PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( MAXSIZE UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) PARTITION BY RANGE (MIC_TAG_ID) INTERVAL( NUMTODSINTERVAL(1, 'DAY')) ( PARTITION VALUES LESS THAN (TO_DATE('01-01-1999', 'MM-DD-YYYY', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE MIC_DATA PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MAXSIZE UNLIMITED MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT ) ) LOGGING NOCOMPRESS NOCACHE NOPARALLEL MONITORING; |
Now try to… Read More
Online Segment Shrink A segment is a logical storage structure that contains data structure (segment type) of database objects. A segment is a set (unordered) of extents. A segment and all its extents are stored in one tablespace. From Oracle Database 10g, we can use the segment shrinking capability to reclaim unused… Read More
Dear Readers, In this articles we will see RAC : Oracle Grid Infrastructure. The Oracle Grid Infrastructure for a standalone server is the Oracle software that provides system support for an Oracle database including volume management, file system, and automatic restart capabilities. If you plan… Read More
