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