Oracle problem creating index organized table using "create as" statement

Question

So I'm trying to create a copy of one of my tables into an index organized table, However I get an error, here is the code.

create table clients2 as
select *
from clients
organization index;

ORA-00933:"SQL command not properly ended"

as subquery is the last part of table_properties which follow physical_properties where you specify storage parameters. — astentx
– astentx, Commented Nov 11, 2021 at 16:23

Roberto Hernandez · Accepted Answer · 2021-11-11 16:11:42Z

4

Your command is wrong.

SQL> create table testiot ( object_id primary key,object_name ) 
     organization index 
     as select object_id,object_name from dba_objects 
     where object_id is not null ;

Table created.

SQL> select count(*) from testiot ;

  COUNT(*)
----------
    208730

Organization index must be in the definition of the table and before as select. On the other hand, you need to define the columns in the table and which one is the primary key for IOT.

answered Nov 11, 2021 at 16:11

Roberto Hernandez

8,5833 gold badges22 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Oracle problem creating index organized table using "create as" statement

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related