Oracle 11g R2 database example user installation instructions

Oracle 11g R2DatabaseExample userThe installation instructions are what we will introduce in this article. We know that in Oracle10g, if we do not select an installation example when creating an instance, after creating an instance, you can also use the scripts under $ ORACLE_HOME/demo/schema to create the script. For details about the creation method, the official documentation provides a detailed description: SampleSchema Scripts and Object Descriptions: templates.

There are also related creation scripts in Oracle 11g R1: Creating.

These scripts will create a series of example users, including HR and OE. These user data allows us to perform some functional tests, and many examples of Oracle documents also use these users.

However, in Oracle 11g R2, mksample cannot be found in the $ ORACLE_HOME/demo/schema/directory. SQL file, and there is no SQL script for creating example users in each separate subdirectory.

In fact, Oracle isolates the installation of these example users into an installation disk, for example, an installation file for the Linuxx86-64 can be downloaded directly from the OTN: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-linx8664soft-100572.html.

Here, Oracle Database 11g Release 2Examples is the example user installation file we need. But now the installation file is more than 500 mb. If you do not want to download such large content, or you only need HR and OE users, you can download the SQL script from the following URL and decompress it to run it.

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

Take HR users as an example:

 
 

  
  
$ ls  
  
  
 
  
  
hr_cre.sqlhr_main.sql hr_popul.sql  
  
  
 
  
  
$ sqlplus / as sysdba  
  
  
 
  
  
SQL> @hr_main.sql 
 
 

The installation instructions for the example users in the Oracle 11g R2 database are introduced here. I hope this introduction will be helpful to you!