Oracle export and import utilities - June 11, 2010 at 15:30 PM
by Babu Kunwar
The import and the export utility are installed along with the database
installation. The main purpose of using this utility is to move the object
inside and outside from database form one database to another
database................
Read Answer
EXPORT utility can be invoked in many ways namely: Command-line entries,
Interactive Export prompts, Parameter files................
Read Answer
As per earlier version of Oracle subset of a table cannot be imported. But since
after its 8i version it was possible. We can do this as:.............
Read Answer
Yes we can view the rate at which table is being imported inside a database. We
can do this by using FEEDBACK keyword. Feedback command tells
IMP....................
Read Answer
As EXPORT/IMPORT rules that Oracle offers import will be done in the same form
as the data was exported. We can do this through INDEXFILE. First we need to
edit this file.................
Read Answer
We can improve efficiency by taking care of certain things:..............
Read Answer
RA-00001: Unique constraint (...) violated. This error is issued if a user tries
to insert an already existing value into a column defined as primary
key................
Read Answer
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...............
SQL*Loader is a bulk loader utility used for moving data from external files
into the Oracle database................
Collections are usually referred to as Composite Data types. Composite type is
one that has components in it. A variable of a composite type contains one or
more scalar types.................
|
