Creating an Extremely Large Index in Oracle

Posted by Rudiger on Stack Overflow See other posts from Stack Overflow or by Rudiger
Published on 2010-01-19T23:44:45Z Indexed on 2010/03/13 22:55 UTC
Read the original article Hit count: 288

Filed under:
|
|
|
|

Can someone look at the linked reference and explain to me the precise statements to run?

Oracle DBA's Guide: Creating a Large Index

Here's what I came up with...

CREATE TEMPORARY TABLESPACE ts_tmp 
TEMPFILE 'E:\temp01.dbf' SIZE 10000M 
REUSE AUTOEXTEND ON EXTENT MANAGEMENT LOCAL;

ALTER USER me TEMPORARY TABLESPACE ts_tmp;

CREATE UNIQUE INDEX big_table_idx ON big_table ( record_id );

DROP TABLESPACE ts_tmp;

Edit 1

After this index was created, I ran an explain plan for a simple query and get this error:

ORA-00959: tablespace 'TS_TMP' does not exist

It seems like it's not temporary at all... :(

© Stack Overflow or respective owner

Related posts about Oracle

Related posts about large