Home » SQL & PL/SQL » SQL & PL/SQL » ALTER TABLE STATEMENT FOR CLUSTER (Oracle 19C/Window 10)
ALTER TABLE STATEMENT FOR CLUSTER [message #678034] Fri, 01 November 2019 07:28 Go to previous message
Bilal Khan
Messages: 126
Registered: April 2010
Location: Pakistan
Senior Member
Dear All.
I create cluster and then want to assign those cluster to created table but it display error.


SQL> create cluster clusempdept (department_id number);

Cluster created.

 1  alter table employees
  2*  CLUSTER clusempdept(department_id)
SQL> /
 CLUSTER clusempdept(department_id)
 *
ERROR at line 2:
ORA-01735: invalid ALTER TABLE option


please help me in this regards, that how i can alter table and assign cluster to that table.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Update null value columns based upon previous non null columns
Next Topic: AWR Report SQL with Bind Variables
Goto Forum:
  


Current Time: Tue Sep 29 09:04:13 CDT 2020