Mark,
With an LMT using UES of 100M, you will get 5 extents.
Jared
"Mark Leith"
<mark@cool-too To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
ls.co.uk> cc:
Sent by: Subject: RE: Doubts reg :Export and
import
[EMAIL PROTECTED]
om
12/03/01 02:50
AM
Please respond
to ORACLE-L
OK - This is of no real need for me, so I'm not going to RTFM :P I thought
I'd just ask..
When using the compress=y option on an export to import a table of 500Mb to
an LMT with a UNIFORM EXTENT size of 100Mb, will it import the table in to
5
extents of 100Mb - or one of 500Mb?
My thought would be that it imports in to 5 extents of 100Mb, but logic
sometimes doesn't prevail - so just curious :)
Cheers
Mark
-----Original Message-----
Shrinivas (MED, Keane)
Sent: 01 December 2001 05:10
To: Multiple recipients of list ORACLE-L
If we use compress=y in export, it will compress the whole table table
data into a single extent. if not, the table will be exported as is with
same extent sizes.
you must be carefule to use compress=y.
'coz in the target, while doing import, your import may fail,if it
doesnt find contiguous space to allocate such a big extent for that
table.(if the source table is very big)
eg: exported table size is 2 gig. Can your system find 2 Gig contiguous
space in the target.? (as this is a single extent)
HTH
Srinivas
-----Original Message-----
Sent: Saturday, December 01, 2001 12:45 AM
To: Multiple recipients of list ORACLE-L
The compress=y compesses your brain while it exports, if you dont want
you brain compressed then do compress=n. But if your brain is all ready
in a compressed state, then they work the opposite.
joe
Alex Hillman wrote:
>
> Another one that apparently has access to e-mail but not to the
internet to
> RTFM :-) . Or maybe s/he knows how to write but cannot read or maybe
can
> read e-mails but cannot read FM etc.
>
> Alex Hillman
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
sangeetha
> > Sent: Wednesday, November 28, 2001 12:16 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Doubts reg :Export and import
> >
> >
> > hi list,
> >
> > what is the exact use of mentioning 'compress' yes
> > or no while exporting....will this store the .dmp file
> > in compressed format in system,if given 'yes'.
> >
> > while importing the dumpfile why is it necessary to
> > give 'fromuser',is 'touser' not enough.
> >
> > sangeetha
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! GeoCities - quick and easy web site hosting, just
$8.95/month.
> > http://geocities.yahoo.com/ps/info1
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: sangeetha
> > 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: Alex Hillman
> 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)
--
Joe Testa, Oracle DBA
Want to have a good time with a bunch of geeks? Check out:
http://www.geekcruises.com/standard_interface/future_cruises.html
I'm presenting, when registering drop my name :)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joe Testa
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: Tatireddy, Shrinivas (MED, Keane)
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:
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).