Oracle test user environment creation method (scott,sh,hr.bi.oe, etc.)

Oracle test user scott,sh,hr.bi.oe and other environment creation methods

Create a scott test user in the Oracle11g environment and call the @? / rdbms/admin/utlsampl.sql script directly. For sh,oe,bi and other test users, you need to download the linux.x64_11gR2_examples.zip package on the official website and install it. The installation method is the same as the installation database. You can extract and run runInstaller installation. After installation, you can generate a mksample.sql script under $ORACLE_HOME/demo/schema, call the script, and follow the prompts to enter relevant information to complete the preparation for the creation of the test data environment.

Linux.x64_11gR2_examples.zip download path:

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