RE: Doubts reg :Export and import

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: root_at_fatcity.com [mailto:root_at_fatcity.com]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: sangeeth_10_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: Alex Hillman
> INET: ahillman_at_erols.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)

--
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: teci_at_the-testas.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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tatireddy, Shrinivas (MED, Keane)
  INET: Shrinivas.Tatireddy_at_med.ge.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: Mark Leith
  INET: mark_at_cool-tools.co.uk

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