Not sure that I fully understand that. Does that mean that tablespace_migrate_to_local does not actually give me any of the advantages of locally managed tablespaces in terms of extent management?
John > -----Original Message----- > From: Mark Leith [SMTP:[EMAIL PROTECTED]] > Sent: 03 July 2002 16:18 > To: Multiple recipients of list ORACLE-L > Subject: RE: dbms_space_admin.tablespace_migrate_to_local > > John, > > No you can't. Here is an excerpt from one of Jonathan Lewis' articles on > his > web site: > > "The final consequence of converting a dictionary tablespace to a locally > managed tablespace is that xxx_tablespaces will show the extent_mangement > to > be "LOCAL", but the allocation_type to be "USER". Clearly, the examples > above show that Oracle will in general be unable to use autoallocate on > the > tablespace, and if it switched to uniform the consequences of having a > unit > size of one block could be disastrous. After conversion, extents will be > allocated according to the normal next_extent methods, with the proviso > that > rounding to the unit size will occur." > > Taken from: > > http://www.jlcomp.demon.co.uk/ch_08.html > > And page that explains getting a "uniform" extent size (scroll to the > bottom > of the page): > > http://p2p.wrox.com/archive/oracle/2001-04/0.asp > > HTH > > Mark > > =================================================== > Mark Leith | T: +44 (0)1905 330 281 > Sales & Marketing | F: +44 (0)870 127 5283 > Cool Tools UK Ltd | E: [EMAIL PROTECTED] > =================================================== > http://www.cool-tools.co.uk > Maximising throughput & performance > > > -----Original Message----- > Sent: 03 July 2002 12:43 > To: Multiple recipients of list ORACLE-L > > > Can this be used to specify the allocation, autoallocate or uniform? > > John > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: John Dunn > 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: Mark Leith > 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: John Dunn 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).
