Results 1 to 4 of 4
  1. #1
    Join Date
    May 2011
    Posts
    2

    Question Unanswered: HR account missing

    when i try to login by using HR account an error message is coming " ORA-o1918: user 'HR' does not exist


    so any one can plz help me regarding this issue to login into HR account

    thanks in advance

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    May 2011
    Posts
    2
    it worked
    thanks

  4. #4
    Join Date
    Apr 2011
    Posts
    1

    Red face HR account missing

    Hi,

    I cannot get it,



    SQL>
    SQL>
    SQL> @C:\oracle\product\10.2.0\db_1\demo\schema\human_r esources\hr_main.sql
    SP2-0310: unable to open file "C:\oracle\product\10.2.0\db_1\demo\schema\hum an_r
    esources\hr_main.sql"
    SQL> rem
    SQL> rem Header: hr8_main.sql 09-jan-01
    SQL> rem
    SQL> rem Copyright (c) 2001, Oracle Corporation. All rights reserved.
    SQL> rem
    SQL> rem Owner : ahunold
    SQL> rem
    SQL> rem NAME
    SQL> rem hr8_main.sql - Main script for hr8 schema
    SQL> rem
    SQL> rem DESCRIPTON
    SQL> rem hr8 (Human Resources) is the smallest and most simple one
    SQL> rem of the Sample Schemas
    SQL> rem
    SQL> rem NOTES
    SQL> rem Run as SYS or SYSTEM
    SQL> rem
    SQL> rem MODIFIED (MM/DD/YY)
    SQL> rem ahunold 10/03/01 - Oracle8i version
    SQL> rem cmcaulay 02/27/02 - added variable for machine name to install on re
    mote db
    SQL> rem kmchorto 08/01/02 - removed role FOR sys login - NOT allowed under o
    racle8
    SQL>
    SQL>
    SQL> SET ECHO OFF
    SQL>
    SQL> PROMPT

    SQL> PROMPT specify password for hr8 as parameter 1:
    specify password for hr8 as parameter 1:
    SQL> DEFINE pass = &1
    Enter value for 1: PROMPT
    SQL> PROMPT specify default tablespace for hr8 as parameter 2:
    specify default tablespace for hr8 as parameter 2:
    SQL> DEFINE tbs = &2
    Enter value for 2: PROMPT
    SQL> PROMPT specify temporary tablespace for hr8 as parameter 3:
    specify temporary tablespace for hr8 as parameter 3:
    SQL> DEFINE ttbs = &3
    Enter value for 3: PROMPT
    SQL> PROMPT specify password for SYS as parameter 4:
    specify password for SYS as parameter 4:
    SQL> DEFINE pass_sys = &4
    Enter value for 4: PROMPT
    SQL> PROMPT specify log path as parameter 5:
    specify log path as parameter 5:
    SQL> DEFINE log_path = &5
    Enter value for 5: PROMPT
    SQL>
    SQL>
    SQL>
    SQL> -- The first dot in the spool command below is
    SQL> -- the SQL*Plus concatenation character
    SQL>
    SQL> DEFINE spool_file = &log_path.hr8_main.log
    SQL> SPOOL &spool_file
    SQL>
    SQL> REM ================================================== =====
    SQL> REM cleanup section
    SQL> REM ================================================== =====
    SQL>
    SQL> DROP USER hr8 CASCADE;
    DROP USER hr8 CASCADE
    *
    ERROR at line 1:
    ORA-01918: user 'HR8' does not exist


    SQL>
    SQL> REM ================================================== =====
    SQL> REM create user
    SQL> REM three separate commands, so the create user command
    SQL> REM will succeed regardless of the existence of the
    SQL> REM DEMO and TEMP tablespaces
    SQL> REM ================================================== =====
    SQL>
    SQL> CREATE USER hr8 IDENTIFIED BY &pass;
    old 1: CREATE USER hr8 IDENTIFIED BY &pass
    new 1: CREATE USER hr8 IDENTIFIED BY PROMPT

    User created.

    SQL>
    SQL> ALTER USER hr8 DEFAULT TABLESPACE &tbs
    2 QUOTA UNLIMITED ON &tbs;
    old 1: ALTER USER hr8 DEFAULT TABLESPACE &tbs
    new 1: ALTER USER hr8 DEFAULT TABLESPACE PROMPT
    old 2: QUOTA UNLIMITED ON &tbs
    new 2: QUOTA UNLIMITED ON PROMPT
    ALTER USER hr8 DEFAULT TABLESPACE PROMPT
    *
    ERROR at line 1:
    ORA-00959: tablespace 'PROMPT' does not exist


    SQL>
    SQL> ALTER USER hr8 TEMPORARY TABLESPACE &ttbs;
    old 1: ALTER USER hr8 TEMPORARY TABLESPACE &ttbs
    new 1: ALTER USER hr8 TEMPORARY TABLESPACE PROMPT
    ALTER USER hr8 TEMPORARY TABLESPACE PROMPT
    *
    ERROR at line 1:
    ORA-00959: tablespace 'PROMPT' does not exist


    SQL>
    SQL> GRANT CONNECT TO hr8;

    Grant succeeded.

    SQL> GRANT RESOURCE TO hr8;

    Grant succeeded.

    SQL>
    SQL> REM ================================================== =====
    SQL> REM grants from sys schema
    SQL> REM ================================================== =====
    SQL>
    SQL>
    SQL>
    SQL> rem KM: 01Aug02 - remove "AS SYSDBA" clause - NOT needed FOR GRANT under Or
    acle8
    SQL> CONNECT sys/&pass_sys&&database_name
    Enter value for database_name: GRANT execute ON sys.dbms_stats TO hr8;
    SP2-0306: Invalid option.
    Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER|SYSASM}]
    where <logon> ::= <username>[/<password>][@<connect_identifier>] [edition=value
    ] | /
    SQL>
    SQL> REM ================================================== =====
    SQL> REM create hr8 schema objects
    SQL> REM ================================================== =====
    SQL>
    SQL> CONNECT hr8/&pass&&database_name
    SP2-0306: Invalid option.
    Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER|SYSASM}]
    where <logon> ::= <username>[/<password>][@<connect_identifier>] [edition=value
    ] | /
    SQL> ALTER SESSION SET NLS_LANGUAGE=American;

    Session altered.

    SQL> ALTER SESSION SET NLS_TERRITORY=America;

    Session altered.

    SQL>
    SQL> --
    SQL> -- create tables, sequences and constraint
    SQL> --
    SQL>
    SQL> @@hr8_cre
    SP2-0310: unable to open file "hr8_cre.sql"
    SQL>
    SQL> --
    SQL> -- populate tables
    SQL> --
    SQL>
    SQL> @@hr8_popul
    SP2-0310: unable to open file "hr8_popul.sql"
    SQL>
    SQL> --
    SQL> -- create indexes
    SQL> --
    SQL>
    SQL> @@hr8_idx
    SP2-0310: unable to open file "hr8_idx.sql"
    SQL>
    SQL> --
    SQL> -- create procedural objects
    SQL> --
    SQL>
    SQL> @@hr8_code
    SP2-0310: unable to open file "hr8_code.sql"
    SQL>
    SQL> --
    SQL> -- add comments to tables and columns
    SQL> --
    SQL>
    SQL> @@hr8_comnt
    SP2-0310: unable to open file "hr8_comnt.sql"
    SQL>
    SQL> --
    SQL> -- gather schema statistics
    SQL> --
    SQL>
    SQL> @@hr8_analz
    SP2-0310: unable to open file "hr8_analz.sql"
    SQL>
    SQL> spool off
    SQL>

Posting Permissions

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