What is the use of PARFILE option in EXP command ?

What is the use of PARFILE option in EXP command ?
by

1 Answer

Answer :

Name of the parameter file to be passed for export.
by

Related questions

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

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.

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.

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/τ)

If the fare of Rajdhani Exp is Rs. 350 and that of Sapt Kranti Exp is Rs. 450 for all classes of passenger then what is the total income of both the trains during 2011 to 2013? 1) Rs. 95 crore 2) Rs. 98 crore 3) Rs. 90 crore 4) Rs. 89 crore 5) Rs. 92.5 crore

Description : If the fare of Rajdhani Exp is Rs. 350 and that of Sapt Kranti Exp is Rs. 450 for all classes of passenger then what is the total income of both the trains during 2011 to 2013? 1) Rs. 95 crore 2) Rs. 98 crore 3) Rs. 90 crore 4) Rs. 89 crore 5) Rs. 92.5 crore

Last Answer : 5) Rs. 92.5 crore

What is the difference between the number of passengers of Sapt Kranti Exp in 2011 and that of Rajdhani Exp in 2006? 1) 1.5 lakh 2) 1 lakh 3) 0.5 lakh 4) 0.75 lakh 5) 0.9 lakh

Description : What is the difference between the number of passengers of Sapt Kranti Exp in 2011 and that of Rajdhani Exp in 2006? 1) 1.5 lakh 2) 1 lakh 3) 0.5 lakh 4) 0.75 lakh 5) 0.9 lakh

Last Answer : 2) 1 lakh

.If the fare of Shatabdi Exp is Rs. 400 for all classes of passenger and the fare of Sampark Kranti Exp is 20% more than that of Shatabdi Exp, then what is the ratio of the income of Shatabdi Exp in 2012 to that of Sampark Kranti Exp in 2013? 1) 1 : 2 2) 2 : 1 3) 1 : 1 4) 3 : 2 5) 5 : 6

Description : .If the fare of Shatabdi Exp is Rs. 400 for all classes of passenger and the fare of Sampark Kranti Exp is 20% more than that of Shatabdi Exp, then what is the ratio of the income of Shatabdi Exp in 2012 to that of Sampark Kranti Exp in 2013? 1) 1 : 2 2) 2 : 1 3) 1 : 1 4) 3 : 2 5) 5 : 6

Last Answer : 5) 5 : 6

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

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

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

WHY USE RMAN ? (for DBA

Description : WHY USE RMAN ? (for DBA

Last Answer : No extra costs Its available free ?RMAN introduced in Oracle 8 it has become simpler with newer versions and easier than user managed backups ?Proper security ?You are 100% sure your ... what need to backed up Knows what is required for recovery Knows what backups are redundant

How does one use ORADEBUG from Server Manager/ SQL*Plus? (for DBA

Description : How does one use ORADEBUG from Server Manager/ SQL*Plus? (for DBA

Last Answer : Execute the "ORADEBUG HELP" command from svrmgrl or sqlplus to obtain a list of valid ORADEBUG commands. Look at these examples: SQLPLUS> REM Trace SQL statements with bind variables SQLPLUS> oradebug ... oradebug lkdebug -a convres SQLPLUS> oradebug lkdebug -r (i.e 0x8066d338 from convres dump)