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

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

1 Answer

Answer :

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

Related questions

What is the use of ANALYSE ( Ver 7) option in EXP command ?

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

Last Answer : A flag to indicate whether statistical information about the exported objects should be written to export dump file.

What is the use of TABLES option in EXP command ?

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

Last Answer : List of tables should be exported.ze)

What is the use of PARFILE option in EXP command ?

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

Last Answer : Name of the parameter file to be passed for export.

What is the use of CONSTRAINTS option in EXP command ?

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

Last Answer : A flag to indicate whether constraints on table need to be exported.

What is the use of FULL option in EXP command ?

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

Last Answer : A flag to indicate whether full databse export should be performed.

What is the use of GRANT option in EXP command?

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

Last Answer : A flag to indicate whether grants on databse objects will be exported or not. Value is 'Y' or 'N'.

What is the use of INDEXES option in EXP command ?

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

Last Answer : A flag to indicate whether indexes on tables will be exported.

What is the use of COMPRESS option in EXP command ?

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.

What is the use of ROWS option in EXP command ?

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

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

What is the use of RECORD option in EXP command?

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

Last Answer : For Incremental exports, the flag indirects whether a record will be stores data dictionary tables recording the export.

What is the use of PARFILE option in EXP command ?

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

Last Answer : Name of the parameter file to be passed for export.

What is the use of RECORD LENGTH option in EXP command ?

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

Last Answer : Record length in bytes.

What is the use of INCTYPE option in EXP command ?

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

Last Answer : Type export should be performed COMPLETE,CUMULATIVE,INCREMENTAL. List the sequence of events when a large transaction that exceeds beyond its optimal value when an entry wraps and causes the rollback segment toexpand into anotion Completes. e. will be written.

How free extents are managed in Ver 6.0 and Ver 7.0 ?

Description : How free extents are managed in Ver 6.0 and Ver 7.0 ?

Last Answer : Free extents cannot be merged together in Ver 6.0. Free extents are periodically coalesces with the neighboring free extent in Ver 7.0

Can you import objects from Oracle ver. 7.3 to 9i?

Description : Can you import objects from Oracle ver. 7.3 to 9i?

Last Answer : Different versions of the import utility are 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. ... 8 database to allow the Oracle 7.3 exp/imp utilities to run against an Oracle 8 database.

What is the use of SHOW option in IMP command ?

Description : What is the use of SHOW option in IMP command ?

Last Answer : A flag to indicate whether file content should be displayed or not.

What is the use of GRANT option in IMP command ?

Description : What is the use of GRANT option in IMP command ?

Last Answer : A flag to indicate whether grants on database objects will be imported

What is the use of INDEXES option in IMP command ?

Description : What is the use of INDEXES option in IMP command ?

Last Answer : A flag to indicate whether import should import index on tables or not.

What is the use of ROWS option in IMP command ?

Description : What is the use of ROWS option in IMP command ?

Last Answer : A flag to indicate whether rows should be imported. If this is set to 'N' then only DDL for database objects will be executed.

What is the use of IGNORE option in IMP command ?

Description : What is the use of IGNORE option in IMP command ?

Last Answer : A flag to indicate whether the import should ignore errors encounter when issuing CREATE commands.

What is the use of FILE option in IMP command ?

Description : What is the use of FILE option in IMP command ?

Last Answer : The name of the file from which import should be performed.

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

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.

What is COMPRESS and CONSISTENT setting in EXPORT utility?

Description : What is COMPRESS and CONSISTENT setting in EXPORT utility?

Last 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 ... . To minimize this possibility, export those tables at a time when updates are not being done.

When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?

Description : When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?

Last Answer : Break. SYSTEM VARIABLES

What command would you use to encrypt a PL/SQL application?

Description : What command would you use to encrypt a PL/SQL application?

Last Answer : WRAP

What command would you use to create a backup control file?

Description : What command would you use to create a backup control file?

Last Answer : Alter database backup control file to trace.

What use of command line parameter cmd file?

Description : What use of command line parameter cmd file?

Last Answer : It is a command line argument that allows you to specify a file that contain a set of arguments for r20run.

WWhat is the use of ANALYZE command ?

Description : WWhat is the use of ANALYZE command ?

Last Answer : To perform one of these function on an index,table, or cluster: - To collect statistics about object used by the optimizer and store them in the data dictionary. - To delete statistics about the ... the structure of the object. - To identify migrated and chained rows of the table or cluster.

Which command will we use to manage (stop, start…) RAC services in command-line mode?

Description : Which command will we use to manage (stop, start…) RAC services in command-line mode?

Last Answer : srvctl

What command would you use to check the availability of the RAC system?

Description : What command would you use to check the availability of the RAC system?

Last Answer : crs_stat -t -v (-t -v are optional)

What command will you use to navigate through ASM files?

Description : What command will you use to navigate through ASM files?

Last Answer : asmcmd

What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ? )

Description : What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ? )

Last Answer : CHOOSE,ALL_ROWS,FIRST_ROWS and RULE.

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

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.

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 ?

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.

Some Basics command of ORACLE 10g on Windows Operating System:

Description : Some Basics command of ORACLE 10g on Windows Operating System:

Last Answer : SQL> show parameter db_name SQL> show parameter instance_name SQL> show parameterdb_block_size (it will show the default block size which is 8KB)

What command will you start to run the installation of Oracle software on Linux?

Description : What command will you start to run the installation of Oracle software on Linux?

Last Answer : runInstaller

Have any of you ever heard the phrase "um ver"?

Description : Have any of you ever heard the phrase "um ver"?

Last Answer : I never heard of it, but I did find this

Pattern ERG (PERG): a. tests the function of the ganglion cells b. uses a checkered board pattern that changes in luminance c. gives the same information as visual evoked response (VER) d. is abnormal in glaucoma

Description : Pattern ERG (PERG): a. tests the function of the ganglion cells b. uses a checkered board pattern that changes in luminance c. gives the same information as visual evoked response (VER) d. is abnormal in glaucoma

Last Answer : is abnormal in glaucoma

In developing a new herbicide, Atwell Chemicals comes up with two formulations. Option 1 is more effective in killing weeds but has a questionable impact on ground water. Option 2 is generally seen as safe but somewhat less effective than its alternative. In choosing Option 2, the firm's stance is consistent with which one of the following moral philosophies? A)Egalitarianism B)Utilitarianism C)Ethical directionism D)Contract theory E)Pluralism

Description : In developing a new herbicide, Atwell Chemicals comes up with two formulations. Option 1 is more effective in killing weeds but has a questionable impact on ground water. Option ... following moral philosophies? A)Egalitarianism B)Utilitarianism C)Ethical directionism D)Contract theory E)Pluralism

Last Answer : B)Utilitarianism

What is the lock option in reports layout

Description : What is the lock option in reports layout

Last Answer : By using the lock option we cannot move the fields in the layout editor outside the frame. This is useful for maintaining the fields .

What is the purpose of the product order option in the column property sheet?

Description : What is the purpose of the product order option in the column property sheet?

Last Answer : To specify the order of individual group evaluation in a cross products.

What email site should I use thats best for iPhone and computer? (exp. hotmail, yahoo, gmail)

Description : What email site should I use thats best for iPhone and computer? (exp. hotmail, yahoo, gmail)

Last Answer : answer:All the ones you just named are compatible, and for the most part there is zero difference in usability in the iPhone's mail app. All use either IMAP or POP3 for their mail protocol, so you' ... and Exchange will only work if your company uses an Exchange server (and has set it up for IMAP).

So, should I watch the finale of Lost or will it just leave me totally confused ? See exp.

Description : So, should I watch the finale of Lost or will it just leave me totally confused ? See exp.

Last Answer : Don’t do it. It will mean nothing to you.

Given below are assertion and reason. Point out if both re true with reason being correct explanation (A). Both are true but reason is not correct exp

Description : Given below are assertion and reason. Point out if both re true with reason being correct explanation (A). Both are true but reason is not correct exp

Last Answer : Given below are assertion and reason. Point out if both re true with reason being correct explanation (A). Both are ... . A. A B. B C. C D. D

is there a place i can test out for cna i have been cert 2 time but have ex. i have 23 years exp?

Description : is there a place i can test out for cna i have been cert 2 time but have ex. i have 23 years exp?

Last Answer : Michiana Healthcare Training, 105 E Jefferson, Suite 210 South Bend, In 46601 Phone: 574-287-8442

i need moey for moveing exp-s?

Description : i need moey for moveing exp-s?

Last Answer : i need moey for moveing exp-s

HOW DO YOU GAIN exp IN JOHNNY UPGRADE?

Description : HOW DO YOU GAIN exp IN JOHNNY UPGRADE?

Last Answer : BE NICE

From collision theory, the reaction rate constant is proportional to (A) exp (-E/RT) (B) exp (-E/2RT) (C) √T (D) T m exp (-E/RT)

Description : From collision theory, the reaction rate constant is proportional to (A) exp (-E/RT) (B) exp (-E/2RT) (C) √T (D) T m exp (-E/RT)

Last Answer : (D) T m exp (-E/RT)

Rate constant 'k' and absolute temperature 'T' are related by collision theory (for bimolecular) as (A) k ∝ T 1.5 (B) k ∝ exp(-E/RT) (C) k ∝ √T (D) k ∝ T

Description : Rate constant 'k' and absolute temperature 'T' are related by collision theory (for bimolecular) as (A) k ∝ T 1.5 (B) k ∝ exp(-E/RT) (C) k ∝ √T (D) k ∝ T

Last Answer : (C) k ∝ √T

The residence time distribution of an ideal CSTR is (A) (1/τ) exp (-t/τ) (B) τ exp (-t/τ) (C) exp (-t/τ) (D) (1/τ) (-t/τ)

Description : The residence time distribution of an ideal CSTR is (A) (1/τ) exp (-t/τ) (B) τ exp (-t/τ) (C) exp (-t/τ) (D) (1/τ) (-t/τ)

Last Answer : (C) exp (-t/τ)