Batch import of dmp backup files in oracle using bat

By using bat batch processing, visual operations on oracle backup files in dmp format of oracle are generally borrowed from PL/SQL. Now we need to export the oracle dmp backup file at the same time, and just use his command to create a bat batch processing file, the content is as follows: sqlplus sys/sys user password @ database as sysdba @ e: \ import \ d. SQL imp \ "userid = db username/db password as sysdba \" full = y file = e: \ import \ ww_1.dmp imp \ "userid = db username/db password as sysdba \" full = y file = e: \ import \ ww_2.dmp imp \ "userid = db username/db password as sysdba \" full = y file = e: \ import \ ww_3.dmp d. the SQL statement is as follows: drop table sys. vio_1; drop table sys. vio2; drop table sys. vio3; quit; batch processing files and d. put the SQL and cmdel backup files in the e: \ import folder and run the bat batch file to import the files.