Expdp Impdp Datapump Interview Questions
Expdp Impdp Datapump Interview Questions
Expdp Impdp Datapump Interview Questions
interview questions
1.What are new features of datapump in 12c?
Ans:-
Test 1
——-
Source – 12.1.0.2 with compatible set to 12.1.0.2
Destination – 11.2.0.2 with compatible 11.2.0
HOST1:/tmp/small_test>expdp test_u/Qwertyu_1234
directory=test_small tables=small_test
logfile=new_exp.log version=10.3
dumpfile=exp_small_to_lower.
// It succeeded.
// Because that Data Pump checks only the major
version number (for example, 10g,11g, 12c), not
specific release numbers (for example, 12.1,10.1,
10.2, 11.1, or 11.2).
31.How to export/import without using external
directory
32.What are the mandatory parameters in impdp an
expdp?
33.How to import already exist schema and
tablespace?
34.Using normal exp/imp, how to export in higher
version (11g) and import into lower version
(10g/9i)?