-
creating user through command prompt
Hi,
I am trying to create user through the command prompt but it does not exit or end it just stays in running mode in the windows scheduler:
Oracle 11.2.0.1 on Windows 2008 R2
following way i am trying to do:
1) create user script: test.sql
CREATE USER test
IDENTIFIED BY test123
DEFAULT TABLESPACE TEST
TEMPORARY TABLESPACE TEMP
PROFILE "DEFAULT"
ACCOUNT UNLOCK QUOTA UNLIMITED ON TEST;
2) command file: createuser.cmd
sqlplus test/user@test as sysdba @e:/script/test.sql
what needs to be done:?
thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|