![oracle 10g sample schema oracle 10g sample schema](http://www.cis.famu.edu/support/10g/Oracle_Database_10g/doc/datamine.102/b14338/img/db_installa.gif)
The mksample script expects 11 parameters. To reset sample schemas to their initial state, use the following syntax from the SQL*Plus command-line interface: systempwd syspwd hrpwd oepwd pmpwd ixpwd shpwd bipwd default_tablespace temp_tablespace log_file_directory/ Use the hr_drop.sql script to drop the HR schema. If you want to return to the initial setup of the HR schema, then use the hr_dn_d.sql script to undo the effects of the hr_dn_c.sql script. To prepare the HR schema for use with the directory capabilities of Oracle Internet Directory, run thehr_dn_c.sql script.
![oracle 10g sample schema oracle 10g sample schema](https://www.hireitpeople.com/images/cards/resumes/131846.jpg)
Ī pair of optional scripts, hr_dn_c.sql and hr_dn_d.sql, is provided as a schema extension. Removes any previously installed HR schemaĬreates the user HR and grants the necessary privilegesĬalls the scripts that create and populate the schema objectsįor a complete listing of the scripts and their functions, refer to. Running hr_main.sql accomplishes the following tasks:
#Oracle 10g sample schema password#
See Also: Oracle Database Security Guide for the minimum password requirementsĮnter an appropriate tablespace, for example, users as the default tablespace for HR specify default tablespace for HR as parameter 2:Įnter temp as the temporary tablespace for HR specify temporary tablespace for HR as parameter 3:Įnter your SYS password specify password for SYS as parameter 4:Įnter the directory path, for example, $ORACLE_HOME /demo/schema/log/, for your log directory specify log path as parameter 5:Īfter the hr_main.sql script runs successfully and the HR schema is installed, you are connected as the user HR. To verify that the schema was created, use the following command: SQL> SELECT table_name FROM user_tables For example: ALTER USER hr ACCOUNT UNLOCK IDENTIFIED BY Password Alternatively, after the installation completes, you can unlock the schemas and reset their passwords by using the ALTER USER. You can unlock the accounts at this point in the installation process. Before you can use a locked account, you must unlock it and reset its password. By default, all sample schemas are locked and their passwords are expired. Īt the end of the installation process, a dialog box displays the accounts that have been created and their lock status.
#Oracle 10g sample schema install#
If you choose not to install the sample schemas at that time, you can add them later by following the instructions in section. Selecting the sample schemas option installs all five schemas (HR, OE, PM, IX, and SH) in the database. When you install Oracle Database with the Oracle Universal Installer, the sample schemas are installed by default if you select the Basic Installation option. Using the Database Configuration Assistant