| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Export - Compress
The COMPRESS option is basically used during the import of the data. If =
the COMPRESS=3DY option is used during the export function then the import =
function will place the data in one initial extent, if the COMPRESS=3DN is =
used the data is retained in the extents of the original table. It =
shouldn't really make any noticable difference during an export as time is =
concerned.
Ron ROgers
DBA
Atl.GA
>>> Kirsten.deWeerd_at_Oranjewoud.nl 07/31/00 11:16AM >>>
Hi,
Small question :
Which is fastest, an export with Compress =3D Y or an export with Compress =
=3D N
???
Oracle 7.2.3 on HP-UX 10.20
Greets,
Kirsten
--=20
Author: Weerd de E.C. Kirsten
INET: Kirsten.deWeerd_at_Oranjewoud.nl=20
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 31 2000 - 10:29:29 CDT
 |
 |