CREATE OR REPLACE DIRECTORY infy_data_dir
AS 'D:\Scripts\DATA_PUMP';

CREATE TABLE test_datapump_tb
( id    NUMBER
, name  VARCHAR2(20)
, ctry_cd VARCHAR2(30)
, CONSTRAINT id_pk PRIMARY KEY(id));

CREATE INDEX IND_908 ON test_datapump_tb(ctry_cd);

INSERT INTO test_datapump_tb VALUES(10, 'Siva', 'IND');
INSERT INTO test_datapump_tb VALUES(20, 'Raj', 'JPN');
INSERT INTO test_datapump_tb VALUES(30, 'Kumar', 'SIN');

SELECT COUNT(*) FROM user_cons_columns WHERE table_name = 'TEST_DATAPUMP_TB';
SELECT COUNT(*) FROM user_indexes WHERE table_name LIKE 'TEST_DATA%';

-- Table Export / Import	

expdp hr/admin@XE tables=test_datapump_tb directory=INFY_DATA_DIR dumpfile=test_datapump.dmp logfile=expdptest_datapump.log

DROP TABLE test_datapump_tb;

impdp hr/admin@XE tables=test_datapump_tb directory=INFY_DATA_DIR dumpfile=test_datapump.dmp logfile=expdptest_datapump.log

SELECT * FROM test_datapump_tb;

-- Schema Exports/Imports

expdp enh_db/enh_db@db10g schemas=SCOTT directory=INFY_DATA_DIR dumpfile=SCOTT.dmp logfile=expdpSCOTT.log

impdp enh_db/enh_db@db10g schemas=SCOTT directory=INFY_DATA_DIR dumpfile=SCOTT.dmp logfile=impdpSCOTT.log


-- Database Exports/Imports

expdp system/password@db10g full=Y directory=INFYCLE_DIR dumpfile=DB10G.dmp logfile=expdpDB10G.log

impdp system/password@db10g full=Y directory=INFYCLE_DIR dumpfile=DB10G.dmp logfile=impdpDB10G.log