Export of table Partition

Export of table Partition:

exp file=exp_f_usd_022007.dmp

log=exp_f_usd_022007.log

tables=

IPDS.F_USD:F_USD001366,

IPDS.F_USD:F_USD001367,

IPDS.F_USD:F_USD001368,

IPDS.F_USD:F_USD001369,

IPDS.F_USD:F_USD001370,

IPDS.F_USD:F_USD001371

buffer=40480000

compress=n



Truncate table Partition:

ALTER TABLE IPDS.F_USD TRUNCATE PARTITION F_USD001366;

ALTER TABLE IPDS.F_USD TRUNCATE PARTITION F_USD001367;

ALTER TABLE IPDS.F_USD TRUNCATE PARTITION F_USD001368;

ALTER TABLE IPDS.F_USD TRUNCATE PARTITION F_USD001369;

ALTER TABLE IPDS.F_USD TRUNCATE PARTITION F_USD001370;

ALTER TABLE IPDS.F_USD TRUNCATE PARTITION F_USD001371;



Import :



imp file=exp_f_usd_022007.dmp log=imp_f_usd_022007.log fromuser=IPDS touser=IPDS

buffer=40480000 ignore=y rows=y