Oracle Import export

Oracle import and export command

<<Previous  Next>>

What are the use of Export and Import command?    Use the IMPORT command to import data into a nickname from a file............. Read answer What are the parameters to be provided while executing Export and Import commands?     The parameters that need to be provided while executing IMPORT or EXPORT commands are: .................. Read answer What is the difference between the SQL*Loader and IMPORT utilities?     SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database................ Read answer What is the difference between the SQL*Loader and IMPORT utilities? SQL*Loader can be used to load data from Delimiter separated files and fixed............ Read answer Difference between locks, latches, enqueues and semaphores Latches are used to protect Oracle data structures to be modified or run by more than one process. They are more restrictive than locks. Locking has a similar concept............... Read answer Oracle processes User process – User process is used in invocation of application software, Data writing process - A database writer process is used to write buffer content into a datafile. They are specifically used to write “dirty block” to data files from the buffer............... Read answer Oracle system privilege A system privilege is the right to perform an action on any schema objects of a particular type............. Read answer Oracle union, intersect and minus UNION: The UNION operator is used to combine the result-set of two or more SELECT statements Tables of both the select statement must have the same number of columns with similar data types. It eliminates duplicates.......... Read answer <<Previous  Next>>