Wednesday, 18 September 2013

export/import backup using batch file in windows


export/import backup using batch file in windows


1. create a batch file named in exp_schema.bat for specific schema

exp stlbas/stlbas@STLBAS_32 owner=RASHID file=D:\cnsstnt.dmp STATISTICS=NONE

1. create a batch file named in exp_table.bat for specific table

exp stlbas/stlbas@STLBAS_32 tables=(ACFGENFD) file=D:\cnsstnt.dmp STATISTICS=NONE

cheer....

No comments:

Post a Comment