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