Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create index without using temp tablespace

781578May 27 2013 — edited May 28 2013
Hello,

i have a great table with over 2.000.000.000 rows. Therefor i want to create an index on column1:

CREATE INDEX "SCHEMA"."INDEX_TABLE1" ON "SCHEMA"."TABLE1" ("STR1")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
STORAGE( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;

If i execute this my temp tablespace will be used and if its full (max 20gb) the creation will be aborted.

Where is my fault to create the index?

With best

Comments

Christopher Jones-Oracle

cur.execute() will execute one SQL or PL/SQL call by sending it to the DB for execution.


Your code appears to be

1) passing in two statements. You need to pass each statement separately.  The BEGIN/END block counts as one statement.

2) passing a SQL*Plus SET command.  This is neither a SQL or PL/SQL statement so the DB won't understand it.

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 25 2013
Added on May 27 2013
#11g, #general-database-discussions, #index
14 comments
5,279 views