• Arun Kumar

Oracle Table and Tables Cluster

In this article we will creating a table cluster inside Oracle. We will also be creating couple of tables inside the cluster table.


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

99 views

Recent Posts

See All

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 Citrix XenServer, you must create your own ISO repository to upload ISO files. Create ISO directo

Oracle Home Cloning

Have you ever imagine how easy it would be if you could just clone an existing installation of Oracle Software from one server to another server without performing a fresh installation! You might have

Oracle External Tables

Oracle SQL*Loader engine allows you to query external tables that are stored on flat files. When I say flat files, I literally mean a file that is stored on OS level. Yes, you can query a flat file th