What does "SELECT * FROM DBA_TABLESPACES" show for the tablespace involved?
----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, May 14, 2002 12:53 PM > Tim, > > Thanks for the explanation. The table I'm looking at > has an initial size 32K while the new extents are all > 16K. Why would this happen? > > thanks > > Gene > --- Tim Gorman <[EMAIL PROTECTED]> wrote: > > SQL*Loader in direct-parallel mode (i.e. > > DIRECT=TRUE, PARALLEL=TRUE) first > > loads into a TEMPORARY segment. After the load > > completes, then the > > TEMPORARY segment is "merged" with the table > > segment. All of the "direct" > > (a.k.a. "append") operations work this way when > > executed in parallel (i.e. > > INSERT /*+ APPEND PARALLEL */, CREATE INDEX ... > > PARALLEL, CREATE TABLE ... > > PARALLEL ... AS SELECT, etc)... > > > > Only SQL*Loader's direct-nonparallel mode (i.e. > > DIRECT=TRUE, PARALLEL=FALSE) > > loads into space on the table segment above the > > current "high-water mark". > > That expected scenario is probably the reason why > > you expect all new extents > > to be sized according to NEXT... > > > > So, the newly added extents were probably "INITIAL" > > extents for the original > > TEMPORARY segments, before they were merged into the > > table segment, perhaps? > > > > ----- Original Message ----- > > To: "Multiple recipients of list ORACLE-L" > > <[EMAIL PROTECTED]> > > Sent: Tuesday, May 14, 2002 10:33 AM > > > > > > > Hi, > > > > > > I'm confused by the way some of my extents are > > > allocated in Oracle. I've talked to Oracle reps, I > > > thing I've posted here before and jsut when I > > thought > > > I got an understanring - ooops, everything is > > gone. So > > > I'll give it another try. I have a table with > > initial > > > set to 32K and next set to 1M. This table is being > > > loaded on a daily basis via Ab initio. The load is > > > done by SQL*loader in direct mode in parallel (I > > > believe it is 8 ways). Now all the segments that > > have > > > been created for this table (besides the 1st one) > > are > > > 16K. Where does this size come from? I thought it > > > should use the NEXT parameter for the new extents, > > but > > > it doesn't. Can someone give me some pointers? > > > > > > thanks > > > > > > Gene > > > > > > __________________________________________________ > > > Do You Yahoo!? > > > LAUNCH - Your Yahoo! Music Experience > > > http://launch.yahoo.com > > > -- > > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > > -- > > > Author: Gurelei > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services -- (858) 538-5051 > > FAX: (858) 538-5051 > > > San Diego, California -- Public Internet > > access / Mailing Lists > > > > > > -------------------------------------------------------------------- > > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > > (or the name of mailing list you want to be > > removed from). You may > > > also send the HELP command for other information > > (like subscribing). > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Tim Gorman > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- (858) 538-5051 FAX: > > (858) 538-5051 > > San Diego, California -- Public Internet > > access / Mailing Lists > > > -------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (or the name of mailing list you want to be removed > > from). You may > > also send the HELP command for other information > > (like subscribing). > > > __________________________________________________ > Do You Yahoo!? > LAUNCH - Your Yahoo! Music Experience > http://launch.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Gurelei > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).