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).
