What is the use of IGNORE option in IMP command ?

What is the use of IGNORE option in IMP command ?
by

1 Answer

Answer :

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

Related questions

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 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 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 CONSISTENT (Ver 7) option in EXP command ?

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.

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

Diff. between VAT and Property Class? imp

Description : Diff. between VAT and Property Class? imp

Last Answer : Named visual attributes define only font, color, and pattern attributes; property classes can contain these and any other properties. You can change the appearance of objects at runtime by ... visual attribute settings take precedence, and any visual attribute properties in the class are ignored.

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

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.

As a teacher, select the best option to ensure your effective presence in the classroom. (A) Use of peer command (B) Making aggressive statements (C) Adoption of well-established posture (D) Being authoritarian

Description : As a teacher, select the best option to ensure your effective presence in the classroom. (A) Use of peer command (B) Making aggressive statements (C) Adoption of well-established posture (D) Being authoritarian

Last Answer : (C) Adoption of well-established posture

Who were the outsiders being referred to as dikus? [Imp.] -History

Description : Who were the outsiders being referred to as dikus? [Imp.] -History

Last Answer : Traders, moneylenders, missionaries, Hindu landlords, and the British were the outsiders being referred to as dikus.

How did partition change the lives and occupations of the refugees? [Imp.] -History

Description : How did partition change the lives and occupations of the refugees? [Imp.] -History

Last Answer : The partition caused massive transfer of populations on both sides of the new border. Muslims left Delhi for Pakistan while their place was taken by equally large numbers of Sikh and Hindu refugees ... their occupation. They had to take up new jobs as hawkers, vendors, carpenters and ironsmiths.

Why did Machlipatnam lose its importance as a port-town by the late 18th century? [V.Imp.] -History

Description : Why did Machlipatnam lose its importance as a port-town by the late 18th century? [V.Imp.] -History

Last Answer : It was because the British shifted their trade to the new ports of Bombay, Madras and Calcutta.

1. Describe governance in the Mauryan empire. [V. Imp.] -History

Description : 1. Describe governance in the Mauryan empire. [V. Imp.] -History

Last Answer : The Mauryan empire consisted of severed different parts which were ruled over differently. The Empire's capital. The areas adjacent to Pataliputra, the capital of the empire, were under the direct ... , , which were vital for transport. Resources, whatever available, were collected as a tribute.

2. How was Ashoka unique? [V. Imp.] -History

Description : 2. How was Ashoka unique? [V. Imp.] -History

Last Answer : Ans: Ashoka was the most famous Mauryan ruler. He was known to take his message amongst the people through inscriptions. His inscriptions were in the people's language Prakrit. Ashoka also remains the only ... in the Kalinga war. Ashoka then became a Buddhist and got the idea of the dhamma'.

8.What was the purpose of Ashoka’s ‘dhamma’? [V. Imp.] -History

Description : 8.What was the purpose of Ashoka’s ‘dhamma’? [V. Imp.] -History

Last Answer : Ans: Ashoka wished to instruct his subjects, for which he introduced his ‘dhamma’.

7. What change came upon Ashoka after the Kalinga war?[V. Imp.] -History

Description : 7. What change came upon Ashoka after the Kalinga war?[V. Imp.] -History

Last Answer : Ans: Ashoka saw that there was a lot of violence in the war and many people were killed. So he decided he would not fight any more wars,

6. What was special about Ashoka as a ruler? [V. Imp.] -History

Description : 6. What was special about Ashoka as a ruler? [V. Imp.] -History

Last Answer : Ans: Ashoka was the first ruler who tried to take his message to his subject through inscriptions.

2.What was the impact of the change in the environment around 12,000 years ago?[V. Imp.] -History

Description : 2.What was the impact of the change in the environment around 12,000 years ago?[V. Imp.] -History

Last Answer : Major changes in the climate of the world with a shift to relatively warm conditions were noticed around 12,000 years ago. As a result, grasslands developed in many regions. This resulted ... cattle. This encouraged people to herd and rear these animals. They also engaged themselves in fishing.

4. What do you know about the work division among men and women in the ancient past? [V. Imp.] -History

Description : 4. What do you know about the work division among men and women in the ancient past? [V. Imp.] -History

Last Answer : It is totally difficult to know about it. However, we can mention atleast two possibilities which are: It is likely that both men and women may have done many of the work like hunting, ... by men. And again, there could have been different practices in different parts of the sub-continent.

1. How were stone tools used in the past? [V. Imp.] -History

Description : 1. How were stone tools used in the past? [V. Imp.] -History

Last Answer : Some stone tools were used to cut meat and bone, scrape bark from trees, and hides le. animal skins, chop fruit, and roots. Some were used as handles of bone or wood. Some were used to make spears and arrows for hunting. Other tools were used to cut wood.

What do you know about the interior of the earth? [V. Imp.] -Geography

Description : What do you know about the interior of the earth? [V. Imp.] -Geography

Last Answer : Our earth is made up of several concentric layers with one inside another. These layers are three in number-crust, mantle smd core. Crust. It is the uppermost layer over the earth's surface. It is ... ni-nickel and fe-ferrous, Le., iron). The central core has a very high temperature and pressure.

Mention various types of rocks IV. [Imp.] -Geography

Description : Mention various types of rocks IV. [Imp.] -Geography

Last Answer : Rocks are of the three types: Igneous rocks Sedimentary rocks Metamorphic rocks Igneous rocks. When the molten magma cools, it becomes solid. Rocks formed in this way are called igneous rocks. ... they chsmge into metamorphic rocks. For example, clay changes into slate and limestone into marble.

What are minerals? How are they useful for mankind? [V. Imp.] -Geography

Description : What are minerals? How are they useful for mankind? [V. Imp.] -Geography

Last Answer : Minerals are naturally occurring substances which have certain physical properties and definite chemical composition. Minerals are very useful for mankind. Some minerals like coal, natural gas and petroleum are used ... . Iron, aluminium, gold, uranium etc. are used in medicine, in Fertilizers, etc