Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Huge primary key creation

Re: Huge primary key creation

From: RR <rickraster_at_hotmail.com>
Date: 8 Jan 2003 18:47:29 -0800
Message-ID: <97b4acf3.0301081847.eb87bc0@posting.google.com> 





Sybrand Bakker <gooiditweg_at_nospam.demon.nl> wrote in message news:<8vpo1v4dhf8oe50ubst0ga6qbils6mgn7q_at_4ax.com>...



> The temp space needed is roughly 2 times the average length of a key

> times the number of records.




> Sybrand Bakker, Senior Oracle DBA




fwiw, adding the extra tempfile worked.


Thank you Sybrand for that information, that didn't even occur to me.



Cheers,



Rick
Received on Wed Jan 08 2003 - 20:47:29 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US