Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

The syntax of the bat-file for the creating database from the dump-file

684278May 22 2009 — edited May 22 2009
Hi, guys.

Sorry for my English, I'm from Russia.

I have bat-file with the following content:

sqlplusw system/mypassword@orcl @anh.sql
imp anh/anh@orcl anh.dmp

It's necessary for me to import schema in the anh.dmp.
Is this bat-file has the right syntax?

The file anh.sql has the following content:

create user anh identified by anh;
grant connect, resource to anh;
grant create view to anh;
exit

And tell me please where is necessary to locate anh.dmp without direction of path to it?

Thanks,Viktor
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 19 2009
Added on May 22 2009
2 comments
1,351 views