What is COMPRESS and CONSISTENT setting in EXPORT utility?

1 Answer

Answer :

COMPRESS
Simply: COMPRESS=n - Allocated space in database for imported table will be exactly as the space required to hold  the data.
COMPRESS=y - The INITIAL extent of the table would be as large as the sum of all the extents allocated to the table  in the original database.
In other words:
The default, COMPRESS=y, causes Export to flag table data for consolidation into one initial extent upon import. If extent sizes are large (for example, because of the PCTINCREASE parameter), the allocated space will be larger  than the space required to hold the data.
If you specify COMPRESS=n, Export uses the current storage parameters, including the values of initial extent size  and next extent size.
If you are using locally managed tablespaces you should always export with COMPRESS=n
CONSISTENT
Default: n. Specifies whether or not Export uses the SET TRANSACTION READ ONLY statement to ensure that the  data seen by Export is consistent to a single point in time and does not change during the execution of the exp  command.
You should specify CONSISTENT=y when you anticipate that other applications will be updating the target data  after an export has started.
If you use CONSISTENT=n, each table is usually exported in a single transaction. However, if a table contains nested  tables, the outer table and each inner table are exported as separate transactions.
If a table is partitioned, each partition is exported as a separate transaction.
Therefore, if nested tables and partitioned tables are being updated by other applications, the data that is  exported could be inconsistent. To minimize this possibility, export those tables at a time when updates are not  being done.

Related questions

Description : How does one backup a database using the export utility? (for DBA

Last Answer : Oracle exports are "logical" database backups (not physical) as they extract data and logical definitions from the database into a file. Other backup strategies normally back-up the physical data ... exports include more information about the database in the export file than user level exports.

Description : What is the use of COMPRESS option in EXP command ?

Last Answer : Flag to indicate whether export should compress fragmented segments into single extents.

Description : What is the use of CONSISTENT (Ver 7) option in EXP command ?

Last Answer : A flag to indicate whether a read consistent version of all the exported objects should be maintained.

Description : What is the most important requirement in order to use RMAN to make consistent hot backups

Last Answer : Your database has to be in ARCHIVELOG mode.

Description : Can one export a subset of a table? (for DBA

Last Answer : From Oracle8i one can use the QUERY= export parameter to selectively unload a subset of the data from a table. Look at this example: exp scott/tiger tables=emp query=\"where deptno=10\"

Description : How does one use the import/export utilities? (for DBA

Last Answer : Look for the "imp" and "exp" executables in your $ORACLE_HOME/bin directory. One can run them interactively, using command line parameters, or using parameter files. Look at the imp/exp parameters ... and export data with the "Schema Manager" GUI that ships with Oracle Enterprise Manager (OEM).

Description : What is import/export and why does one need it? (for DBA

Last Answer : The Oracle export (EXP) and import (IMP) utilities are used to perform logical database backup and recovery. They are also used to move Oracle data from one machine, database or schema to ... corruption. Ensure that all the data can be read. . Transporting tablespaces between databases . Etc.

Description : What are the different kind of export backups?

Last Answer : Full back - Complete database Incremental - Only affected tables from last incremental date/full backup date. Cumulative backup - Only affected table from the last cumulative date/full backup date.

Description : What are the common Import/ Export problems? (for DBA

Last Answer : ORA-00001: Unique constraint (...) violated - You are importing duplicate rows. Use IGNORE=NO to skip tables that already exist (imp will give an error if the object is re-created). ORA-01555: ... =Y import parameter to ignore these errors, but be careful as you might end up with duplicate rows.

Description : How can one improve Import/ Export performance? (for DBA

Last Answer : EXPORT: . Set the BUFFER parameter to a high value (e.g. 2M) . Set the RECORDLENGTH parameter to a high value (e.g. 64K) . Stop unnecessary applications to free-up ... the import parameter file to avoid time consuming ANALYZE statements . Remember to run the indexfile previously created

Description : Can one export to multiple files?/ Can one beat the Unix 2 Gig limit? (for DBA

Last Answer : From Oracle8i, the export utility supports multiple output files. This feature enables large exports to be divided into files whose sizes will not exceed any operating system limits (FILESIZE= parameter). When ... > scott.exp.gz & # feed the pipe exp userid=scott/tiger file=exp.pipe ...

Description : Can one import/export between different versions of Oracle? (for DBA

Last Answer : Different versions of the import utility is upwards compatible. This means that one can take an export file created from an old export version, and import it using a later version of the import utility. ... database to allow the Oracle 7.3 exp/imp utilities to run against an Oracle 8 database.

Description : What utility is used to create a physical backup?

Last Answer : Either rman or alter tablespace begin backup will do..

Description : Explain the use of setting GLOBAL_NAMES equal to TRUE.

Last Answer : Setting GLOBAL_NAMES dictates how you might connect to a database. This variable is either TRUE or FALSE and if it is set to TRUE it enforces database links to have the same name as the remote database to which they are linking.

Description : What is path setting for DLL?

Last Answer : Make sure you include the name of the DLL in the FORMS45_USEREXIT variable of the ORACLE.INI file, or rename the DLL to F45XTB.DLL. If you rename the DLL to F45XTB.DLL, replace the existing F45XTB.DLL in the ORAWINBIN directory with the new F45XTB.DLL.

Description : What are the built-ins that are used for setting the LOV properties at runtime?

Last Answer : get_lov_property set_lov_property

Description : What is the diff. bet. setting up of parameters in reports 2.0 reports2.5?

Last Answer : LOVs can be attached to parameters in the reports 2.5 parameter form.

Description : What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?

Last Answer : The Optimizer chooses Cost_based approach and optimizes with the goal of best throughput if statistics for atleast one of the tables accessed by the SQL statement exist in the data dictionary. Otherwise the OPTIMIZER chooses RULE_based approach.

Description : What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ? What are the factors that affect OPTIMIZER in choosing an Optimization approach ?

Last Answer : Answer The OPTIMIZER_MODE initialization parameter Statistics in the Data Dictionary the OPTIMIZER_GOAL parameter of the ALTER SESSION command hints in the statement.

Description : What is Automatic Management of Segment Space setting?

Last Answer : Oracle9i New Feature Series: Automatic Segment Space Management Automatic Segment Space Management (ASSM) introduced in Oracle9i is an easier way of managing space in a segment using bitmaps. It ... . ASSM can be specified only with the locally managed tablespaces (LMT). Oracle uses bitmaps

Description : What is PCTFREE and PCTUSED Setting?

Last Answer : PCTFREE is a block storage parameter used to specify how much space should be left in a database block for future updates. For example, for PCTFREE=10, Oracle will keep on adding new rows to a block ... SQL> SELECT pct_free FROM user_tables WHERE table_name = 'EMP'; PCT_FREE ---------- 10

Description : What is PCT Increase setting?

Last Answer : PCTINCREASE refers to the percentage by which each next extent (beginning with the third extend) will grow. The size of each subsequent extent is equal to the size of the previous extent plus this ... /O may be required to fetch the additional blocks where extent maps of the segment are stored.

Description : Is it damaging to compress the sides of a memory foam mattress?

Last Answer : It might forgive you, but it will never forget ;)

Description : Are there any tools to compress images into "tweetable" (≤140 characters) text?

Last Answer : answer:Holy Cow that's ambitious. There is so little room in 140 characters (x 8 bits per character, that's 1120 bits of data). The image would have to be tiny and/or lack color/grey-scale variation. ... image, and some way to get the twitter text into that app. Kind of a fun geeky exercise though .

Description : Is there a defrag/compress file program out there that I can download?

Last Answer : Here are good defrag and compression tools.

Description : How do I compress pdfs comprised of images and sound bites without losing quality?

Last Answer : Have you looked at PDF Shrink ?

Description : What is it about celebrity that seems to compress a lifetime into a few short years?

Last Answer : Artists can be a crazy breed. Personally, I think these behavior patterns have more to do with selfishness, narcissism, self absorption and a lack of consideration to others.

Description : What is a good file compress app for Mac OS X?

Last Answer : Go for the Terminal! Compress Files in Mac OS X Terminal, UNIX Wikipedia agrees, gzip is better than zip: gzip is not to be confused with the ZIP archive format, which also ... , because it compresses files individually and cannot take advantage of redundancy between files (solid compression).

Description : Why doesn't handbreak.org not always work to compress some DVDs and is there a better appllication?

Last Answer : hate to ask, but are you using “handbrake” or ” handbreak”?

Description : How do I compress a large PDF from a mac so I can send it VIA email?

Last Answer : answer:Do you have the original source text as a file? It sounds like your PDF is made from each page as an image, which makes it much much bigger (and harder to read) than if it uses the ... would be to regenerate the PDF so it's small. The easiest way to do this is probably using OpenOffice.

Description : Compress a download before downloading?

Last Answer : No that is impossible. You can always try using something other than ftp to download. Like wget . Or you could setup a server of your own on your home network, use wget to download it to your box, use the command line to zip it back up and download it from your server.

Description : Write the steps to compress a picture. -Technology

Last Answer : Steps to compress a picture in a document are as follows:(a) Step 1: Select the picture.(b) Step 2: Click the Picture Tools Format tab.(c) Step 3: Click the Compress Pictures in the ... Compression options: as per the requirement.(g) Step 7: Click OK button in the Compression Settings dialog box.

Description : According To the Schwarzschild Radius what size would you have to compress the earth to make a black hole? -Space

Last Answer : You can define a Schwarzschild Radius based solely on total mass, i.e. Rs=2GMc2. If you plug in the mass of the earth, the radius is about 9 mm --- which is how small you would have to compress it to make a black-hole.

Description : How to GZIP compress an existing file in Python -Web-Development

Last Answer : answer:

Description : Maybe blonde is the question, but how to compress, wrap files, or what. I want to send pictures to a friend and tell me to compress them because it will definitely go into your inbox. How to compress?   

Last Answer : Not complicated at all. Download the program WINRAR HERE. It is very easy to install. Start the program, browse for the files to be packaged. Once you have selected them, right-click on the selection ... still name the compressed file, or you can choose to have ZIP, RAR, or other compression.     

Description : How to cool the foot effectively?

Last Answer : Frozen peas in a bag are suitable, they do not flow and can be shaped beautifully. :)

Description : buick 2005 lacross / how to compress rear calliper piston when changing brakes

Last Answer : Need Answer

Description : Help me about compress a PDF document?

Last Answer : Compressing PDF is all about reducing the size of the file, usually if you check through google you will find free platforms that compress your PDF file for you free, the outcome is that the fonts, ... back to PDF, but the best option is to check those platforms on google for free compression.

Description : What's the best software to compress video to a smaller size without losing quality?

Last Answer : Adobe Premiere is generally considered the industry standard in terms of video compression.

Description : Why can't we compress a solid block of steel?

Last Answer : In a solid like steel, the atoms are packed as close together as possible. This being the case they can not be compressed together further so you can not compress (reduce the volume of) a solid block of steel.

Description : Prefix for compress?

Last Answer : Do

Description : A supercharger is used to compress a. air b. gasoline c. fuel oil d. all of the above

Last Answer : ANSWER a. air

Description : A cold compress is applied on the forehead of a person suffering from high fever. Why?

Last Answer : Ans: Evaporation causes cooling. As the water evaporates, it absorbs heat from the forehead and helps in reducing the temperature.

Description : Purpose of air lift pump is to (A) Compress air (B) Lift compressed air (C) Lift water from a well by using compressed air (D) Lift air under negative pressure

Last Answer : (C) Lift water from a well by using compressed air

Description : In ____________ is used to compress images. A. MPEG B. JPEG C. either a or b D. none of the above

Last Answer : B. JPEG

Description : A two stage compressor is used to compress an ideal gas. The gas is cooled to the initial temperature after each stage. The intermediate pressure for the minimum total work requirement should be equal to ... final pressures respectively) (A) Logarithmic (B) Arithmetic (C) Geometric (D) Harmonic

Last Answer : (C) Geometric

Description : What horse power is required to isothermally compress 800 ft^3 of Air per minute from 14.7 psia to 120 psia?  A. 28 hp  B.108 hp  C.256 hp  D.13900 hp Formula: W= p1V1 ln (p1/p2) Power = dW / dt

Last Answer : 108 hp

Description : When is Run Length Encoding used? A. When we want to compress patterns of data B. When we want to decompress patterns of data C. When we want to encode running videos

Last Answer : A. When we want to compress patterns of data

Description : When is Run Length Encoding used? A. When we want to compress patterns of data B. When we want to decompress patterns of data C. When we want to encode running videos

Last Answer : A. When we want to compress patterns of data

Description : What are the main reasons to compress data? A. To reduce secondary storage space B. To maximise the available RAM memory C. To speed up network transmission times D. To optimise the data

Last Answer : A. To reduce secondary storage space