3 Replies Latest reply: Sep 2, 2012 12:39 AM by 954348 RSS

    Uploading .sql files.

    954348
      Using a book entitled 'Oracle By Example'

      Happily using Oracle Express to create tables and follow YouTube tutorials but now want more experience. The book comes with various files.

      According the help file with this book, I need to create a user called 'STUDENT' with a password of 'learn'

      I go to command prompt and type: sqlplus system....sign in.

      I issue the command at the SQL prompt:

      'create user STUDENT identified by password:learn'

      After hitting the enter key, I see a '2' instead of 'user created'

      What am I doing wrong?

      Edited by: 951345 on 01-Sep-2012 10:37
        • 1. Re: Uploading .sql files.
          sb92075
          951345 wrote:
          Using a book entitled 'Oracle By Example'

          Happily using Oracle Express to create tables and follow YouTube tutorials but now want more experience. The book comes with various files.

          According the help file with this book, I need to create a user called 'STUDENT' with a password of 'learn'

          I go to command prompt and type: sqlplus system....sign in.

          I issue the command at the SQL prompt:

          'create user STUDENT identified by password:learn'

          After hitting the enter key, I see a '2' instead of 'user created'

          What am I doing wrong?

          Edited by: 951345 on 01-Sep-2012 10:37
          10:41:49 SQL> create user student identified by learn;
          
          User created.
          
          10:42:05 SQL> 
          How do I ask a question on the forums?
          SQL and PL/SQL FAQ
          • 2. Re: Uploading .sql files.
            orafad
            >
            What am I doing wrong?
            You are not looking up the syntax for create user statement in the SQL Reference manual. (Perhaps also XE specific docu library details ways to create users via gui interfaces, in addition to command line.)
            • 3. Re: Uploading .sql files.
              954348
              Thanks.