![]() ![]() How to create Sample Schemas in Oracle 1. ORA- 1. 96. 13. May 1. Kirill Loifman The Oracle Database Sample Schemas provide a common platform for examples in each release of Oracle Database. They are easy to use for testing and training purposes. All Oracle Database documentation and training materials refer to the Sample Schemas environment. This guide contains information required to install Oracle Database 11g Release 1 (11.1) on various platforms of Linux. Ensure that you review information related to. Oracle OpenWorld 2017- San Francisco: Connect, learn, and discover this fall at Oracle OpenWorld 2017. Join industry and product thought leaders October 1-5 to take. Following are Oracle Sample Schemas– OE (Order Entry schema) – useful for dealing with matters of intermediate complexity. Many data types are available in this schema, including non- scalar data types.– HR (Human Resources schema) – useful for introducing basic topics. An extension to this schema supports Oracle Internet Directory demos.– PM (Product Media schema) is dedicated to multimedia data types.– IX (Information Exchange main schema) includes a set of schemas for demonstrate Oracle Advanced Queuing capabilities– SH (Sales History schema) is designed to allow for demos with large amounts of data. An extension to this schema provides support for advanced analytic processing.– SCOTT – old- fashioned famous schema with its two prominent tables EMP and DEPT that is used by Oracle for many years.– BI – includes only synonyms on SH schema. With this simplicity I personally found difficulties in creating Sample Schemas in Oracle 1. ![]()
In fact I could not do it in a standard way with Oracle installation binaries before 1. If somebody experienced similar issues, I give below the way how to install Sample Schemas manually. Create a new fresh Oracle database with following prerequisites– with US7. ASCII character set– with database components (JVM, XML DB, Multimedia, Spatial)– WITHOUT Sample Schemas component– No new tablespaces should be created after the database creation. Create Sample Schemas manually following the procedure belowcd $ORACLE_HOME/demo/schemasqlplus /nolog@mkplug. Enter passwords for input parameters 1- 7 and the following parameters: Enter value for 8: example. Enter value for 9: example. Enter value for 1. Enter value for 1. Enter value for 1. All directories above should be correct and correspond to your $ORACLE_HOME which is my case is /opt/app/oracle/product/1. As a result of executing the above SQL script, a new tablespace EXAMPLE is attached to a database with file number 5, and the Sample Schemas will show up in the database. This procedure does not work in case one of the below– non- US7. ASCII database– example tablespace was created during the database creation– at least one new tablespace is created after the database creation. You might get following error while executing the script if the next available database file number < > 5: declare*ERROR at line 1: ORA- 1. ORA- 1. 98. 70: error while restoring backup piece/opt/app/oracle/product/1. ORA- 1. 96. 15: some files not found in backup set. ORA- 1. 96. 13: datafile 6 not found in backup set. ORA- 0. 65. 12: at "SYS. DBMS_BACKUP_RESTORE", line 5. ORA- 0. 65. 12: at line 3. If SCOTT user is missing. After the successful SQL script execution some may miss a famous SCOTT user. Unfortunately it might not be a part of Sample Schemas data file before Oracle binaries 1. You can create it later using a below SQL script: $ORACLE_HOME/rdbms/admin/utlsampl. Enjoyed this article? Please share it with others using the social site of your choice: Filed under. How- to, Oracle · Tags. Oracle, schema, SQL.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
October 2017
Categories |