EXP utility ensure that CONSTRAINTS & TRIGGERS parameters are set to Y default - Oracle Tablespaces

Q.  Which utility ensure that the CONSTRAINTS and TRIGGERS parameters are set to Y the default?
- Published on 28 Jul 15

a. EXP
b. IMP
c. Both A & B
d. None of the above

ANSWER: EXP
 

    Discussion

  • Nirja Shah   -Posted on 31 Aug 15
    - If any of the tablespaces have XMLTypes, you must use EXP instead of a Data Pump.

    EXP - It is known as Export Utility.
    - The Export utility provides a simple way for you to transfer data objects between Oracle databases, even if they reside on platforms with different hardware and software configurations.
    - When you run Export against an Oracle database, objects (such as tables) are extracted, followed by their related objects (such as indexes, comments, and grants), if any.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)