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: 285
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