I want to install the sample database for my Oracle database server.
Prerequisite
Oracle Database installed. You can refer here for installing the Oracle Database.
Software
Install the Oracle Example
the 11.2.0 installer does not recognize the newer version of package therefore, if the system already has the newer version of the packages, it can be ignore.
After the installer completed, the mksample.sql script is populate to under $ORACLEHOME/demo/schema directory. We can use it to create the sample schema.
Install the Sample Schema
I am going to use the mksample.sql to create the sample schema. This is the primary script and will invoke other script to create the correspond schema. If only need some schema, you can just invoke the individual script. For example, the HR schema can be created by invoking hr_main.sql under human_resources folder.
@$ORACLE_HOME/demo/schema/mksample.sql
The log file path must be end with / .
After scripts, we can exam the log file in the log directory to see if there is any error.
@?/demo/schema/human_resources/hr_main.sql
ReplyDeletegives me an error :-
SP2-0310: unable to open file "F:\app\Welcome\product\11.2.0\dbhome_1/demo/schema/human_resources/hr_main.sql"
please help
@?/demo/schema/human_resources/hr_main.sql
ReplyDeletegives me an error :-
SP2-0310: unable to open file "F:\app\Welcome\product\11.2.0\dbhome_1/demo/schema/human_resources/hr_main.sql"
please help
You should install examples first.
DeleteContains examples of how to use the Oracle Database. Download if you are new to Oracle and want to try some of the examples presented in the Documentation
Nice & Informative Blog !
ReplyDeleteQuickBooks is an accounting software that has rapidly captured the global market,QuickBooks Payroll Error PS036 while working on this software. To get rid of such problems, call us at 1-855-977-7463 and get immediate support for QuickBooks issues.