title: Creating an Extremely Large Index in Oracle
body: <p>Can someone look at the linked reference and explain to me the precise statements to run?</p>
  
  <p><a href="http://download-west.oracle.com/docs/cd/B28359_01/server.111/b28310/indexes003.htm#i1006643" rel="nofollow noreferrer">Oracle DBA's Guide: Creating a Large Index</a></p>
  
  <p>Here's what I came up with...</p>
  
  <pre><code>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;
  </code></pre>
  
  <p><strong>Edit 1</strong></p>
  
  <p>After this index was created, I ran an explain plan for a simple query and get this error:</p>
  
  <pre><code>ORA-00959: tablespace 'TS_TMP' does not exist
  </code></pre>
  
  <p>It seems like it's not temporary at all... :(</p>