LMTs came with 8i (8.1.5 afaik) ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 01, 2002 3:18 PM
> I don't believe LMTs are supported in 7.3.x... > > > --- Don Granaman <[EMAIL PROTECTED]> wrote: > > With compress=N, you will get essentially the same mish-mash of > > extents you > > had previously - unless you are importing into a LMT. > > > > You have basically two options: > > > > 1) Pre-create the objects with a storage clause specifying the extent > > sizes > > you want - with initial and next the same size. Then import with > > ignore=Y. > > Of course, if you drop the users, you will have to recreate them > > before > > pre-creating the objects. This is the only option for > > dictionary-managed > > tablespaces to get uniform extents. (Hint: imp ... > > indexfile=somefilename.sql ..., edit somefilename.sql to (1) > > uncomment the > > create table statements and (2) modify storage clauses, then run > > somefilename.sql. If the export is large, you may wish to split this > > into > > two parts - one for the tables and one for the indexes and > > constraints. (It > > is a little more complicated than it might seem at first, but isn't > > too bad. > > One possible approach is to perform one export with rows=Y indexes=N > > constraints=N and another with rows=N indexes=Y constraints=Y. > > Details left > > as an exercise for the reader ;-) > > > > 2) Convert the tablespace(s) to LMT(s) with uniform extents - or drop > > and > > recreate them as such - prior to the import. > > > > In the vast majority of cases, (2) is preferred. > > > > Don Granaman > > [certifiable OraSaurus] > > > > ----- Original Message ----- > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Saturday, June 29, 2002 11:53 PM > > > > > > Hello, > > > > Running Oracle 7.3.4.4 on Win2k. > > Trying to implement unlimited extents of the same size. (Same size > > works > > for us). > > Set the tablespace defaults > > Dumped the users > > Dropped the users > > Imported the users > > > > Tables still had the same mish-mash of extents and max extents 121 > > > > Here are my dump params > > USERID = system/************@****** > > FILE = c:\dumps\test.dmp > > LOG = c:\dumps\test.log > > FULL = Y > > buffer=1000000 > > consistent=y > > compress=n > > > > That did not work so I tried dumping an individual user > > USERID = system/*****@******* > > FILE = c:\dumps\test.dmp > > LOG = c:\dumps\test.log > > FULL = N > > COMPRESS = N > > owner=restek > > > > Still get mish-mash extents on import. > > > > The load was always: > > USERID = system/******@***** > > FILE = c:\dumps\test.dmp > > LOG = c:\dumps\test.dmprs.implog > > FROMUSER = restek > > TOUSER = restek > > > > My quick test of create table tmp_xyz as select * from xyz gives me > > the > > result I want. > > > > Any suggestions? Do I have to wait until I upgrade to 8i or 9i? > > > > TIA > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Robert Monical > > 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: Don Granaman > > 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!? > Yahoo! - Official partner of 2002 FIFA World Cup > http://fifaworldcup.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > 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: Alexandre Gorbatchev 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).