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).
Received on Mon Jul 01 2002 - 08:18:19 CDT
