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

Jim Smith

SQL Developer doesn't put anything in the registry.
From your reference to SID, I assume you are looking for a database. SQL Developer is only a client tool, it doesn't come with a database.
You will need to download and install the database software as well. The easiest thing to do is to download express edition
Oracle Database Express Edition (XE) Downloads (0 Bytes)

What Jim said, we don't have an installer, we don't put anything into the registry.
I think we'll check the registry for an Oracle Client/HOME, but we write all of our application settings to your AppData folder, under Roaming Profiles.

1 - 2
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,235 views