Transportable tablespace - Definition - Oracle Tablespaces

Q.  A transportable tablespace set consists of datafiles for the set of tablespaces being transported and an export file containing structural information (metadata) for the set of tablespaces we use ______
- Published on 12 Aug 15

a. Data Pump
b. EXP
c. IMP
d. Both A & B

ANSWER: Both A & B
 

    Discussion

  • Nirja Shah   -Posted on 31 Aug 15
    - Datapump - Datapump is a server based bulk data movement infrastructure that supersedes the old import and export utilities.
    - The old export/ import tools are still available, but do not support all Oracle 10g and 11g features. The new utilities are named expdp and impdp.

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