Oracle Database Discussions

Hi

DOes anyone know how to run sqlplus and import command in a .bat file?

I am trying to import about 10 database dump files into a database, what I want to do is to run sql statement to create tablespace/user in a .bat file first and then run import command to import the database dump files.

I wrote the following scripts in batch file:

sqlplus sm03/sm03@smdb1 @c:\table.sql

where table.sql contain the sql to creat tablespace and user. THis part work fine when I tested it.

But I don't know how to get back to commandline and continue to run the import command after sqlplus command finish. I hope just one click the bat file and it will run sqlplus command and import comand as well

Any idea?

Thanks

Li




THanks

Li

Message was edited by:
user542038