DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: creating user through command prompt

  1. #1
    Join Date
    Aug 2008
    Posts
    123

    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

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Quote Originally Posted by midora View Post
    what needs to be done:?
    I would make sure that the word exit was the last line in the sql script.


    as in:

    Code:
    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;
    exit

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width