This discussion is archived
3 Replies Latest reply: Feb 9, 2013 11:50 PM by prog RSS

HR Schema

prog Newbie
Currently Being Moderated
Hi everybody
I have installed Oracle Database 11g Express Edition which comes with Application Express 4.0.2.
I want to test the HR schema..is it coming with it or I have to install it
how can I change the HR password because I want to test the Jaspersoft (ireport)
  • 1. Re: HR Schema
    Mahmoud_Rabie Journeyer
    Currently Being Moderated
    Dear BeenaIT,

    Let's assume the following:
    1)you are using Linux
    2)and your hostname is myhost
    3)and your sys password is mysyspassword
    4)the new hr password is hr

    From the command line write the following
    [oracle@myhost ~]$ sqlplus sys/mysyspassword as sysdba
    
    SQL*Plus: Release 11.2.0.1.0 Production on Sun Feb 10 09:50:04 2013
    
    Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
    With the Partitioning, Automatic Storage Management, Oracle Label Security, OLAP,
    Data Mining, Oracle Database Vault and Real Application Testing options
    
    SQL> alter user hr identified by hr;
    
    User altered. 
    If the question is answered, please close it as answered and give the points where earned ...

    Best Regards
    Mahmoud
  • 2. Re: HR Schema
    prog Newbie
    Currently Being Moderated
    using window 7 ?
  • 3. Re: HR Schema
    Mahmoud_Rabie Journeyer
    Currently Being Moderated
    No difference, just use SQLPlus of the installed instance
    and use connect
    connect sys/mysyspassword as sysdba
    then write
    SQL> alter user hr identified by hr;

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points