• Arun Kumar

Oracle Table and Tables Cluster

Let us create an index cluster on employees and department table under scott user


Create Cluster Table

CREATE CLUSTER employees_departments_cluster
(department_id NUMBER(2));


Create Index on Cluster Table


Without create an index on cluster table, you cannot proceed. This is an Index Cluster

CREATE INDEX idx_emp_dept_cluster ON CLUSTER employees_departments_cluster;


Create Tables Inside Cluster


Create tables inside cluster based on cluster key column

CREATE TABLE EMP_CLUST 
CLUSTER employees_departments_cluster (deptno)
as select * from emp;

CREATE TABLE DEPT_CLUST 
CLUSTER employees_departments_cluster (deptno)
as select * from dept;


Drop Table Inside Cluster

DROP TABLE EMP_CLUST;
DROP TABLE DEPT_CLUST;


Drop Cluster

DROP CLUSTER employees_departments_cluster


Recent Posts

See All

MySQL Installation on Linux

This article demonstrates MySQL installation on Oracle Enterprise Linux 6.5 version. Installation of MySQL Make sure you are able to connect internet via virtual machine. Try to ping google.com and pr

Add ISO image storage repository on XenServer

If you have used VMware ESXI, its very easy to upload ISO files to the data store and create VMs. With XenServer, you must create your own ISO repository to upload ISO files. Create ISO directory Acce

Automate RMAN Backups using Shell Scripts

In a real environment, off course you will not manually trigger all the Oracle database backups. You need an automated mechanism to trigger RMAN backups. In this article we will look at RMAN backup au

  • Facebook
  • Twitter
  • YouTube
  • Instagram

© 2020 by DBA Genesis

Feedback