IMPORT & EXPORT using exp & imp command


Hi ,

Below command will create .dmp file from you database.

exp DBUNAME/PASSWORD@SID GRANTS=Y TABLES=(MV_BILL_CTL)
file= Folderpath\or_exp.dmp log =Folderpath\or_exp.log direct=y;


C:\>imp DBUNAME/PASSWORD@SID file = Folderpath\or_exp.dmp log = Folderpath\or_exp.dmp commit=Y;

Comments

Popular Posts