Oracle export and import utilities

          

Oracle export and import utilities


<<Previous   Next>>
Oracle export and import utilities - June 11, 2010 at 15:30 PM by Babu Kunwar
What is import/export? Explain its usage.

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

Explain how to use the import/export utilities.

EXPORT utility can be invoked in many ways namely: Command-line entries, Interactive Export prompts, Parameter files................
Read Answer

Can we export a subset of a table? Explain how

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

Can we monitor how fast a table is imported? How?

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

Explain how to import tables to a different tablespace?

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

Explain how to improve Import/Export performance?

We can improve efficiency by taking care of certain things:..............
Read Answer

Describe the common Import/Export problems

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

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

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

What is composite data type?

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



Write your comment - Share Knowledge and Experience


 

 
Interview questions
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring