LMTs came with 8i (8.1.5 afaik)
- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Monday, July 01, 2002 3:18 PM
> I don't believe LMTs are supported in 7.3.x...
>
>
> --- Don Granaman <granaman_at_cox.net> 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" <ORACLE-L_at_fatcity.com>
> > 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: tech_at_restek.com
> >
> > 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: ListGuru_at_fatcity.com (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: granaman_at_cox.net
> >
> > 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: ListGuru_at_fatcity.com (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: wisernet100_at_yahoo.com
>
> 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: ListGuru_at_fatcity.com (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: alexandre.gorbatchev_at_avermann.de
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: ListGuru_at_fatcity.com (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).
Received on Mon Jul 01 2002 - 08:58:29 CDT
