OraFAQ Forum: SQL & PL/SQL » ALTER TABLE STATEMENT FOR CLUSTER

Home » SQL & PL/SQL » SQL & PL/SQL » ALTER TABLE STATEMENT FOR CLUSTER (Oracle 19C/Window 10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ALTER TABLE STATEMENT FOR CLUSTER [message #678034]

Fri, 01 November 2019 07:28

Bilal Khan
Messages: 128
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.

Report message to a moderator

[Message index]

		ALTER TABLE STATEMENT FOR CLUSTER By: Bilal Khan on Fri, 01 November 2019 07:28
		Re: ALTER TABLE STATEMENT FOR CLUSTER By: John Watson on Fri, 01 November 2019 07:30
		Re: ALTER TABLE STATEMENT FOR CLUSTER By: Bilal Khan on Fri, 01 November 2019 07:36
		Re: ALTER TABLE STATEMENT FOR CLUSTER By: BlackSwan on Fri, 01 November 2019 07:50
		Re: ALTER TABLE STATEMENT FOR CLUSTER By: Michel Cadot on Fri, 01 November 2019 08:32
		Re: ALTER TABLE STATEMENT FOR CLUSTER By: John Watson on Fri, 01 November 2019 08:39
		Re: ALTER TABLE STATEMENT FOR CLUSTER By: Bilal Khan on Fri, 01 November 2019 22:40
		Re: ALTER TABLE STATEMENT FOR CLUSTER By: Michel Cadot on Sat, 02 November 2019 01:25

Previous Topic:	Update null value columns based upon previous non null columns
Next Topic:	AWR Report SQL with Bind Variables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 13:45:36 CDT 2024