Oracle 11gR2 database example user installation instructions

Source: Internet
Author: User

If you want to install the sample user in Oracle11gR2, you can use the example provided in the oracle official documentation. You can create an instance at the same time. You can also create a database after installing the database software database.
The original storage location of the sample file in linux: $ ORACLE_HOME/demo/schema

Oracle@www.bkjia.com ~ $ Cd $ ORACLE_HOME/demo/schema // the script for creating an example in oracle10g and oracle11gR1 is stored here.
[Oracle@www.bkjia.com schema] $ ll
Total 80
Drwxr-xr-x. 2 oracle oinstall 4096 Feb 5 bus_intelligence
-Rw-r --. 1 oracle oinstall 2322 Apr 3 2009 drop_sch. SQL
Drwxr-xr-x. 2 oracle oinstall 4096 Feb 5 human_resources
Drwxr-xr-x. 2 oracle oinstall 4096 Feb 5 log
-Rw-r --. 1 oracle oinstall 1754 Feb 5 mk_dir. SQL
-Rw-r --. 1 oracle oinstall 1754 Feb 5 mk_dir. SQL .ouibak
-Rw-r --. 1 oracle oinstall 1600 Aug 16 2006 mk_dir. SQL .sbs
-Rw-r --. 1 oracle oinstall 27373 Jun 30 2007 mkplug. SQL
Drwxr-xr-x. 3 oracle oinstall 4096 Feb 5 order_entry
Drwxr-xr-x. 2 oracle oinstall 4096 Feb 5 sales_history
-Rw-r --. 1 oracle oinstall 15246 May 10 2005 sted_mkplug. SQL .dbl

However, there is no mksample. SQL script, and none of the scripts can be used to create an oracle demo.

Oracle provides an independent 500 multi-MB Installation File in oracle11gR2 for installation example:

Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-linx8664soft-100572.html

The installation package to be downloaded is named Oracle Database 11g Release 2 Examples.

Oracle interprets the installation package as follows:

Contains 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.

If you only need hr users for demonstration, you can download from this link:

Http://st-curriculum.oracle.com/obe/jdev/obe11jdev/11/common/files/sample_schema_scripts.zip

Decompress the downloaded file to the hr directory and use FileZilla to upload it to the VM.

Oracle@www.bkjia.com hr $ ls

Hr_cre. SQL hr_main. SQL hr_popul. SQL

[Oracle@www.bkjia.com hr] $ sqlplus/as sysdba

SQL> @ hr_main. SQL

Note that the creation script for commonly used scott users is located at: % ORACLE_HOME % \ rdbms \ admin \ scott. SQL

Scott. SQL in oracle11gR2 in linux is not in this directory.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.