{"id":7571,"date":"2016-04-13T15:32:56","date_gmt":"2016-04-13T13:32:56","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-2-oracle\/"},"modified":"2016-04-13T15:32:56","modified_gmt":"2016-04-13T13:32:56","slug":"the-almost-same-sample-schema-for-all-major-relational-databases-2-oracle","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-2-oracle\/","title":{"rendered":"The (almost) same sample schema for all major relational databases (2) – Oracle"},"content":{"rendered":"

In the last post<\/a> we looked at how to install the “Dell DVD Store Database Test Suite”<\/a> into a PostgreSQL 9.5.2 database. In this post we’ll do the same with an Oracle database.
\n<\/p>\n

The starting point is exactly the same. Download the generic “ds21.tar.gz”<\/a> and the vendor specific “ds21_oracle.tar.gz”<\/a> files and transfer both to the node the hosts the Oracle database:<\/p>\n

\noracle@oel12102:\/var\/tmp\/ [PROD] ls\nds21_oracle.tar.gz  ds21.tar.gz\n<\/pre>\n
Once extracted we have almost the same structure as in the last post for PostgreSQL:<\/p>\n
\noracle@oel12102:\/var\/tmp\/ds2\/ [PROD] ls -l\ntotal 132\n-rw-r--r--. 1 oracle oinstall  5308 Aug 12  2010 CreateConfigFile.pl\ndrwxr-xr-x. 5 oracle oinstall    73 May 31  2011 data_files\ndrwxr-xr-x. 2 oracle oinstall  4096 Dec  2  2011 drivers\n-rw-r--r--. 1 oracle oinstall 30343 May 13  2011 ds2.1_Documentation.txt\n-rw-r--r--. 1 oracle oinstall 10103 Nov  9  2011 ds2_change_log.txt\n-rw-r--r--. 1 oracle oinstall  1608 Jul  1  2005 ds2_faq.txt\n-rw-r--r--. 1 oracle oinstall  2363 May  5  2011 ds2_readme.txt\n-rw-r--r--. 1 oracle oinstall  5857 Apr 21  2011 ds2_schema.txt\n-rw-r--r--. 1 oracle oinstall 18013 May 12  2005 gpl.txt\n-rw-r--r--. 1 oracle oinstall 32827 Nov  9  2011 Install_DVDStore.pl\ndrwxr-xr-x. 5 oracle oinstall  4096 May 31  2011 oracleds2\n<\/pre>\n
The only difference is the “oracleds2” directory. In contrast to the PostgreSQL version you do not need to create user as the scripts will connect as sysdba:<\/p>\n
\noracle@oel12102:\/var\/tmp\/ds2\/oracleds2\/ [PROD] pwd\n\/var\/tmp\/ds2\/oracleds2\noracle@oel12102:\/var\/tmp\/ds2\/oracleds2\/ [PROD] head oracleds2_create_all.sh\n# oracleds2_create_all.sh\n# start in .\/ds2\/oracleds2\ncd .\/build\nsqlplus \"\/ as sysdba\" @oracleds2_create_tablespaces_small.sql\nsqlplus \"\/ as sysdba\" @oracleds2_create_db_small.sql\ncd ..\/load\/cust\nsh oracleds2_cust_sqlldr.sh\ncd ..\/orders\nsh oracleds2_orders_sqlldr.sh\nsh oracleds2_orderlines_sqlldr.sh\n<\/pre>\n
Lets go:<\/p>\n
\noracle@oel12102:\/var\/tmp\/ds2\/ [PROD] pwd\n\/var\/tmp\/ds2\noracle@oel12102:\/var\/tmp\/ds2\/ [PROD] chmod +x Install_DVDStore.pl\noracle@oel12102:\/var\/tmp\/ds2\/ [PROD] .\/Install_DVDStore.pl \nPlease enter following parameters: \n***********************************\nPlease enter database size (integer expected) : 100\nPlease enter whether above database size is in (MB \/ GB) : MB\nPlease enter database type (MSSQL \/ MYSQL \/ PGSQL \/ ORACLE) : ORACLE\nPlease enter system type on which DB Server is installed (WIN \/ LINUX) : LINUX\n***********************************\n\nFor Oracle database scripts, total 4 paths needed to specify where cust, index, ds_misc and order dbfiles are stored. \n\nIf only one path is specified, it will be assumed same for all dbfiles. \n\nFor specifying multiple paths use ; character as seperator to specify multiple paths \n\nPlease enter path(s) (; seperated if more than one path) where Database Files will be stored (ensure that path exists) : \/u02\/oradata\/PROD\/\n***********************************\nInitializing parameters...\n***********************************\nDatabase Size: 100 \nDatabase size is in MB \nDatabase Type is ORACLE \nSystem Type for DB Server is LINUX \nFile Paths : \/u02\/oradata\/PROD\/ \n***********************************\n\nCalculating Rows in tables!! \nSmall size database (less than 1 GB) \nRatio calculated : 10 \nCustomer Rows: 200000 \nOrder Rows \/ month: 10000 \nProduct Rows: 100000 \n\nCreating CSV files....\nStarting to create CSV data files.... \nFor larger database sizes, it will take time.\nDo not kill the script till execution is complete. \n\nCreating Customer CSV files!!! \n1 100000 US S 0 \n100001 200000 ROW S 0 \n\nCustomer CSV Files created!! \n\nCreating Orders, Orderlines and Cust_Hist csv files!!! \n\nCreating Order CSV file for Month jan !!! \n1 10000 jan S 1 0 100000 200000 \n\nCreating Order CSV file for Month feb !!! \n10001 20000 feb S 2 0 100000 200000 \n\nCreating Order CSV file for Month mar !!! \n20001 30000 mar S 3 0 100000 200000 \n\nCreating Order CSV file for Month apr !!! \n30001 40000 apr S 4 0 100000 200000 \n\nCreating Order CSV file for Month may !!! \n40001 50000 may S 5 0 100000 200000 \n\nCreating Order CSV file for Month jun !!! \n50001 60000 jun S 6 0 100000 200000 \n\nCreating Order CSV file for Month jul !!! \n60001 70000 jul S 7 0 100000 200000 \n\nCreating Order CSV file for Month aug !!! \n70001 80000 aug S 8 0 100000 200000 \n\nCreating Order CSV file for Month sep !!! \n80001 90000 sep S 9 0 100000 200000 \n\nCreating Order CSV file for Month oct !!! \n90001 100000 oct S 10 0 100000 200000 \n\nCreating Order CSV file for Month nov !!! \n100001 110000 nov S 11 0 100000 200000 \n\nCreating Order CSV file for Month dec !!! \n110001 120000 dec S 12 0 100000 200000 \n\nAll Order, Orderlines, Cust_Hist CSV files created !!! \n\nCreating Inventory CSV file!!!! \n\nInventory CSV file created!!!! \n\nCreating product CSV file!!!! \n\nProduct CSV file created!!!! \n\nStarted creating and writing build scripts for Oracle database... \n\nCompleted creating and writing build scripts for Oracle database!!\n\nAll database build scripts(shell and sql) are dumped into their respective folders. \n\nThese scripts are created from template files in same folders with '_generic_template' in their name. \n\nScripts that are created from template files have '_' 100 MB in their name. \n\nUser can edit the sql script generated for customizing sql script for more DBFiles per table and change the paths of DBFiles.\n\nNow Run CreateConfigFile.pl perl script in ds2 folder which will generate configuration file used as input to the driver program.\n<\/pre>\n
Looks fine so lets try to load (for Oracle a separate load script was generated):<\/p>\n
\noracle@oel12102:\/var\/tmp\/ds2\/oracleds2\/ [PROD] pwd\n\/var\/tmp\/ds2\/oracleds2\noracle@oel12102:\/var\/tmp\/ds2\/oracleds2\/ [PROD] chmod +x oracleds2_create_all_100MB.sh\noracle@oel12102:\/var\/tmp\/ds2\/oracleds2\/ [PROD] .\/oracleds2_create_all_100MB.sh\n...\n  INSERT INTO \"DS2\".\"CATEGORIES\" (CATEGORY, CATEGORYNAME) VALUES (1,'Action')\n                    *\nERROR at line 1:\nORA-01950: no privileges on tablespace 'DS_MISC'\n\n\n  INSERT INTO \"DS2\".\"CATEGORIES\" (CATEGORY, CATEGORYNAME) VALUES (2,'Animation')\n                    *\nERROR at line 1:\nORA-01950: no privileges on tablespace 'DS_MISC'\n...\n<\/pre>\n
Hm. Quotas seem to be missing. The script that creates the user is this one:<\/p>\n
\n\/var\/tmp\/ds2\/oracleds2build\/oracleds2_create_db_100MB.sql\n<\/pre>\n
Lets add the quotas for the tablespaces there:<\/p>\n
\noracle@oel12102:\/var\/tmp\/ds2\/oracleds2\/ [PROD] head -21 build\/oracleds2_create_db_100MB.sql\n\n-- DS2 Database Build Scripts\n-- Dave Jaffe  Todd Muirhead 8\/31\/05\n-- Copyright Dell Inc. 2005\n\n-- User\n\nSET TERMOUT OFF\nDROP USER DS2 CASCADE;\nSET TERMOUT ON\n\nCREATE USER DS2\n  IDENTIFIED BY ds2\n  TEMPORARY TABLESPACE \"TEMP\"\n  DEFAULT TABLESPACE \"DS_MISC\"\n  ;\nALTER USER DS2 QUOTA UNLIMITED ON CUSTTBS;\nALTER USER DS2 QUOTA UNLIMITED ON INDXTBS;\nALTER USER DS2 QUOTA UNLIMITED ON DS_MISC;\nALTER USER DS2 QUOTA UNLIMITED ON ORDERTBS;\n<\/pre>\n
… and try again (sorry for the long output, just want to be complete here):<\/p>\n
\noracle@oel12102:\/var\/tmp\/ds2\/oracleds2\/ [PROD] pwd\n\/var\/tmp\/ds2\/oracleds2\noracle@oel12102:\/var\/tmp\/ds2\/oracleds2\/ [PROD] .\/oracleds2_create_all_100MB.sh\noracle@oel12102:\/var\/tmp\/ds2\/oracleds2\/ [PROD] .\/oracleds2_create_all_100MB.sh\n\nSQL*Plus: Release 12.1.0.2.0 Production on Tue Apr 12 13:29:06 2016\n\nCopyright (c) 1982, 2014, Oracle.  All rights reserved.\n\n\nConnected to:\nOracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production\nWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing options\n\nConnected.\nSQL> spool CreateDS2_Tablespaces.log\nSQL> \nSQL> --Currently this template assumes need for only single datafile per table\nSQL> --This might impact performance for larger database sizes, so either user needs to edit the generated script from this template or change logic in perl script to generate required build table space script\nSQL> --Paramters that need to be changed acc to database size are - number of datafiles per table, initial size of data file and size of increments for data file in case of overflow\nSQL> \nSQL> --Paths for windows should be like this : c:oracledbfiles\nSQL> --paths for linux should be like this : \/oracledbfiles\/\nSQL> \nSQL> CREATE TABLESPACE \"CUSTTBS\" LOGGING DATAFILE '\/u02\/oradata\/PROD\/cust_1.dbf' SIZE 1000M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED\tEXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;\nCREATE TABLESPACE \"CUSTTBS\" LOGGING DATAFILE '\/u02\/oradata\/PROD\/cust_1.dbf' SIZE 1000M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED\tEXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO\n*\nERROR at line 1:\nORA-01543: tablespace 'CUSTTBS' already exists\n\n\nSQL> ALTER TABLESPACE \"CUSTTBS\" ADD DATAFILE '\/u02\/oradata\/PROD\/cust_2.dbf' SIZE 1000M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED ;\nALTER TABLESPACE \"CUSTTBS\" ADD DATAFILE '\/u02\/oradata\/PROD\/cust_2.dbf' SIZE 1000M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED\n*\nERROR at line 1:\nORA-01537: cannot add file '\/u02\/oradata\/PROD\/cust_2.dbf' - file already partof database\n\n\nSQL> CREATE TABLESPACE \"INDXTBS\" LOGGING DATAFILE '\/u02\/oradata\/PROD\/indx_1.dbf' SIZE 1000M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED\tEXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;\nCREATE TABLESPACE \"INDXTBS\" LOGGING DATAFILE '\/u02\/oradata\/PROD\/indx_1.dbf' SIZE 1000M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED\tEXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO\n*\nERROR at line 1:\nORA-01543: tablespace 'INDXTBS' already exists\n\n\nSQL> ALTER TABLESPACE \"INDXTBS\" ADD DATAFILE '\/u02\/oradata\/PROD\/indx_2.dbf' SIZE 1000M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED ;\nALTER TABLESPACE \"INDXTBS\" ADD DATAFILE '\/u02\/oradata\/PROD\/indx_2.dbf' SIZE 1000M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED\n*\nERROR at line 1:\nORA-01537: cannot add file '\/u02\/oradata\/PROD\/indx_2.dbf' - file already partof database\n\n\nSQL> CREATE TABLESPACE \"DS_MISC\" LOGGING DATAFILE '\/u02\/oradata\/PROD\/ds_misc.dbf' SIZE 500M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;\nCREATE TABLESPACE \"DS_MISC\" LOGGING DATAFILE '\/u02\/oradata\/PROD\/ds_misc.dbf' SIZE 500M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO\n*\nERROR at line 1:\nORA-01543: tablespace 'DS_MISC' already exists\n\n\nSQL> CREATE TABLESPACE \"ORDERTBS\" LOGGING DATAFILE '\/u02\/oradata\/PROD\/order_1.dbf' SIZE 1000M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;\nCREATE TABLESPACE \"ORDERTBS\" LOGGING DATAFILE '\/u02\/oradata\/PROD\/order_1.dbf' SIZE 1000M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO\n*\nERROR at line 1:\nORA-01543: tablespace 'ORDERTBS' already exists\n\nSQL> ALTER TABLESPACE \"ORDERTBS\" ADD DATAFILE '\/u02\/oradata\/PROD\/order_2.dbf' SIZE 1000M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED ;\nALTER TABLESPACE \"ORDERTBS\" ADD DATAFILE '\/u02\/oradata\/PROD\/order_2.dbf' SIZE 1000M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED\n*\nERROR at line 1:\nORA-01537: cannot add file '\/u02\/oradata\/PROD\/order_2.dbf' - file already partof database\n\n\nSQL> spool off\nSQL> exit;\nDisconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production\nWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing options\n\nSQL*Plus: Release 12.1.0.2.0 Production on Tue Apr 12 13:29:06 2016\n\nCopyright (c) 1982, 2014, Oracle.  All rights reserved.\n\n\nConnected to:\nOracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production\nWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing options\n\n\nUser created.\n\n\nUser altered.\n\n\nUser altered.\n\n\nUser altered.\n\n\nUser altered.\n\n\nGrant succeeded.\n\n\nTable created.\n\n\nTable created.\n\n\nTable created.\n\n\nTable created.\n\n\nTable created.\n\n\nTable created.\n\n\nTable created.\n\n\n1 row created.\n\n\n1 row created.\n\n\n1 row created.\n\n\n1 row created.\n\n\n1 row created.\n\n\n1 row created.\n\n\n1 row created.\n\n\n1 row created.\n\n\n1 row created.\n\n\n1 row created.\n\n\n1 row created.\n\n\n1 row created.\n\n\n1 row created.\n\n\n1 row created.\n\n\n1 row created.\n\n\n1 row created.\n\n\nTable created.\n\n\nSequence created.\n\n\nSequence created.\n\n\nPackage created.\n\n\nCommit complete.\n\nDisconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production\nWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing options\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:10 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:10 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\nPath used:      Direct\nPath used:      Direct\n\nLoad completed - logical record count 100000.\n\nTable DS2.CUSTOMERS, partition US_PART:\n  100000 Rows successfully loaded.\n\nCheck the log file:\n  us.log\nfor more information about the load.\n\nLoad completed - logical record count 100000.\n\nTable DS2.CUSTOMERS, partition ROW_PART:\n  100000 Rows successfully loaded.\n\nCheck the log file:\n  row.log\nfor more information about the load.\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:12 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:12 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:12 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:12 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:12 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:12 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:12 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:12 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:12 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:12 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:12 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:12 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\nPath used:      Direct\nPath used:      Direct\nPath used:      Direct\nPath used:      Direct\nPath used:      Direct\nPath used:      Direct\nPath used:      Direct\nPath used:      Direct\nPath used:      Direct\nPath used:      Direct\nPath used:      Direct\nPath used:      Direct\n\nLoad completed - logical record count 10000.\n\nTable DS2.ORDERS, partition FEB2009:\n  10000 Rows successfully loaded.\n\nCheck the log file:\n  feb_orders.log\nfor more information about the load.\n\nLoad completed - logical record count 10000.\n\nTable DS2.ORDERS, partition JUL2009:\n  10000 Rows successfully loaded.\n\nCheck the log file:\n  jul_orders.log\nfor more information about the load.\n\nLoad completed - logical record count 10000.\n\nTable DS2.ORDERS, partition SEP2009:\n  10000 Rows successfully loaded.\n\nCheck the log file:\n  sep_orders.log\nfor more information about the load.\n\nLoad completed - logical record count 10000.\n\nLoad completed - logical record count 10000.\n\nLoad completed - logical record count 10000.\n\nLoad completed - logical record count 10000.\n\nTable DS2.ORDERS, partition APR2009:\n  10000 Rows successfully loaded.\n\nCheck the log file:\n  apr_orders.log\nfor more information about the load.\n\nLoad completed - logical record count 10000.\n\nTable DS2.ORDERS, partition JAN2009:\n  10000 Rows successfully loaded.\n\nCheck the log file:\n  jan_orders.log\nfor more information about the load.\n\nLoad completed - logical record count 10000.\n\nTable DS2.ORDERS, partition DEC2009:\n  10000 Rows successfully loaded.\n\nCheck the log file:\n  dec_orders.log\nfor more information about the load.\n\nTable DS2.ORDERS, partition OCT2009:\n  10000 Rows successfully loaded.\n\nCheck the log file:\n  oct_orders.log\nfor more information about the load.\n\nTable DS2.ORDERS, partition MAY2009:\n  10000 Rows successfully loaded.\n\nCheck the log file:\n  may_orders.log\nfor more information about the load.\n\nTable DS2.ORDERS, partition JUN2009:\n  10000 Rows successfully loaded.\n\nCheck the log file:\n  jun_orders.log\nfor more information about the load.\n\nLoad completed - logical record count 10000.\n\nLoad completed - logical record count 10000.\n\nTable DS2.ORDERS, partition NOV2009:\n  10000 Rows successfully loaded.\n\nCheck the log file:\n  nov_orders.log\nfor more information about the load.\n\nTable DS2.ORDERS, partition MAR2009:\n  10000 Rows successfully loaded.\n\nCheck the log file:\n  mar_orders.log\nfor more information about the load.\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:14 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:14 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\n\nLoad completed - logical record count 10000.\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:14 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:14 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\n\nTable DS2.ORDERS, partition AUG2009:\n  10000 Rows successfully loaded.\n\nCheck the log file:\n  aug_orders.log\nfor more information about the load.\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:14 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:14 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:14 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:14 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:14 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:14 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:14 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:14 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:14 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\nPath used:      Direct\nPath used:      Direct\nPath used:      Direct\nPath used:      Direct\nPath used:      Direct\nPath used:      Direct\nPath used:      Direct\nPath used:      Direct\nPath used:      Direct\nPath used:      Direct\nPath used:      Direct\nPath used:      Direct\nPath used:      Direct\n\nLoad completed - logical record count 49487.\n\nTable DS2.ORDERLINES, partition NOV2009:\n  49487 Rows successfully loaded.\n\nCheck the log file:\n  nov_orderlines.log\nfor more information about the load.\n\nLoad completed - logical record count 50081.\n\nTable DS2.ORDERLINES, partition MAY2009:\n  50081 Rows successfully loaded.\n\nCheck the log file:\n  may_orderlines.log\nfor more information about the load.\n\nLoad completed - logical record count 49791.\n\nLoad completed - logical record count 49763.\n\nTable DS2.ORDERLINES, partition FEB2009:\n  49791 Rows successfully loaded.\n\nCheck the log file:\n  feb_orderlines.log\nfor more information about the load.\n\nTable DS2.ORDERLINES, partition MAR2009:\n  49763 Rows successfully loaded.\n\nCheck the log file:\n  mar_orderlines.log\nfor more information about the load.\n\nLoad completed - logical record count 49784.\n\nTable DS2.ORDERLINES, partition OCT2009:\n  49784 Rows successfully loaded.\n\nCheck the log file:\n  oct_orderlines.log\nfor more information about the load.\n\nLoad completed - logical record count 50251.\n\nTable DS2.ORDERLINES, partition DEC2009:\n  50251 Rows successfully loaded.\n\nCheck the log file:\n  dec_orderlines.log\nfor more information about the load.\n\nLoad completed - logical record count 50234.\n\nTable DS2.ORDERLINES, partition SEP2009:\n  50234 Rows successfully loaded.\n\nCheck the log file:\n  sep_orderlines.log\nfor more information about the load.\n\nLoad completed - logical record count 49918.\n\nTable DS2.ORDERLINES, partition JUN2009:\n  49918 Rows successfully loaded.\n\nCheck the log file:\n  jun_orderlines.log\nfor more information about the load.\n\nLoad completed - logical record count 50159.\n\nLoad completed - logical record count 50206.\n\nLoad completed - logical record count 50718.\n\nTable DS2.ORDERLINES, partition AUG2009:\n  50159 Rows successfully loaded.\n\nCheck the log file:\n  aug_orderlines.log\nfor more information about the load.\n\nTable DS2.ORDERLINES, partition APR2009:\n  50206 Rows successfully loaded.\n\nCheck the log file:\n  apr_orderlines.log\nfor more information about the load.\n\nTable DS2.ORDERLINES, partition JUL2009:\n  50718 Rows successfully loaded.\n\nCheck the log file:\n  jul_orderlines.log\nfor more information about the load.\n\nLoad completed - logical record count 49687.\n\nTable DS2.CUST_HIST:\n  49687 Rows successfully loaded.\n\nCheck the log file:\n  jan_cust_hist.log\nfor more information about the load.\n\nLoad completed - logical record count 49687.\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:15 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\n\nTable DS2.ORDERLINES, partition JAN2009:\n  49687 Rows successfully loaded.\n\nCheck the log file:\n  jan_orderlines.log\nfor more information about the load.\nPath used:      Direct\n\nLoad completed - logical record count 49791.\n\nTable DS2.CUST_HIST:\n  49791 Rows successfully loaded.\n\nCheck the log file:\n  feb_cust_hist.log\nfor more information about the load.\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:15 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\nPath used:      Direct\n\nLoad completed - logical record count 49763.\n\nTable DS2.CUST_HIST:\n  49763 Rows successfully loaded.\n\nCheck the log file:\n  mar_cust_hist.log\nfor more information about the load.\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:15 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\nPath used:      Direct\n\nLoad completed - logical record count 50206.\n\nTable DS2.CUST_HIST:\n  50206 Rows successfully loaded.\n\nCheck the log file:\n  apr_cust_hist.log\nfor more information about the load.\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:15 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\nPath used:      Direct\n\nLoad completed - logical record count 50081.\n\nTable DS2.CUST_HIST:\n  50081 Rows successfully loaded.\n\nCheck the log file:\n  may_cust_hist.log\nfor more information about the load.\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:15 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\nPath used:      Direct\n\nLoad completed - logical record count 49918.\n\nTable DS2.CUST_HIST:\n  49918 Rows successfully loaded.\n\nCheck the log file:\n  jun_cust_hist.log\nfor more information about the load.\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:15 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\nPath used:      Direct\n\nLoad completed - logical record count 50718.\n\nTable DS2.CUST_HIST:\n  50718 Rows successfully loaded.\n\nCheck the log file:\n  jul_cust_hist.log\nfor more information about the load.\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:15 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\nPath used:      Direct\n\nLoad completed - logical record count 50159.\n\nTable DS2.CUST_HIST:\n  50159 Rows successfully loaded.\n\nCheck the log file:\n  aug_cust_hist.log\nfor more information about the load.\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:15 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\nPath used:      Direct\n\nLoad completed - logical record count 50234.\n\nTable DS2.CUST_HIST:\n  50234 Rows successfully loaded.\n\nCheck the log file:\n  sep_cust_hist.log\nfor more information about the load.\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:16 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\nPath used:      Direct\n\nLoad completed - logical record count 49784.\n\nTable DS2.CUST_HIST:\n  49784 Rows successfully loaded.\n\nCheck the log file:\n  oct_cust_hist.log\nfor more information about the load.\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:16 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\nPath used:      Direct\n\nLoad completed - logical record count 49487.\n\nTable DS2.CUST_HIST:\n  49487 Rows successfully loaded.\n\nCheck the log file:\n  nov_cust_hist.log\nfor more information about the load.\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:16 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\nPath used:      Direct\n\nLoad completed - logical record count 50251.\n\nTable DS2.CUST_HIST:\n  50251 Rows successfully loaded.\n\nCheck the log file:\n  dec_cust_hist.log\nfor more information about the load.\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:16 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\nPath used:      Direct\n\nLoad completed - logical record count 100000.\n\nTable DS2.PRODUCTS:\n  100000 Rows successfully loaded.\n\nCheck the log file:\n  prod.log\nfor more information about the load.\n\nSQL*Loader: Release 12.1.0.2.0 - Production on Tue Apr 12 13:29:16 2016\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\nPath used:      Direct\n\nLoad completed - logical record count 100000.\n\nTable DS2.INVENTORY:\n  100000 Rows successfully loaded.\n\nCheck the log file:\n  inv.log\nfor more information about the load.\n\nSQL*Plus: Release 12.1.0.2.0 Production on Tue Apr 12 13:29:16 2016\n\nCopyright (c) 1982, 2014, Oracle.  All rights reserved.\n\nLast Successful login time: Tue Apr 12 2016 13:29:16 +02:00\n\nConnected to:\nOracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production\nWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing options\n\n\nIndex created.\n\n\nTable altered.\n\n\nIndex created.\n\n\nIndex created.\n\n\nTable altered.\n\n\nIndex created.\n\n\nTable altered.\n\n\nTable altered.\n\n\nIndex created.\n\n\nTable altered.\n\n\nTable altered.\n\n\nIndex created.\n\n\nTable altered.\n\n\nIndex created.\n\n\nIndex created.\n\n\nIndex created.\n\nDisconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production\nWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing options\n\nSQL*Plus: Release 12.1.0.2.0 Production on Tue Apr 12 13:29:19 2016\n\nCopyright (c) 1982, 2014, Oracle.  All rights reserved.\n\nLast Successful login time: Tue Apr 12 2016 13:29:16 +02:00\n\nConnected to:\nOracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production\nWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing options\n\nConnected.\n\"DS2\".\"PRODUCTS\"(actor) INDEXTYPE IS CTXSYS.CONTEXT\n                                            *\nERROR at line 2:\nORA-29833: indextype does not exist\n\n\n\"DS2\".\"PRODUCTS\"(title) INDEXTYPE IS CTXSYS.CONTEXT\n                                            *\nERROR at line 2:\nORA-29833: indextype does not exist\n\n\nDisconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production\nWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing options\n\nSQL*Plus: Release 12.1.0.2.0 Production on Tue Apr 12 13:29:19 2016\n\nCopyright (c) 1982, 2014, Oracle.  All rights reserved.\n\nLast Successful login time: Tue Apr 12 2016 13:29:19 +02:00\n\nConnected to:\nOracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production\nWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing options\n\n\nTable created.\n\n\nProcedure created.\n\n\nProcedure created.\n\n\nProcedure created.\n\n\nWarning: Procedure created with compilation errors.\n\n\nWarning: Procedure created with compilation errors.\n\n\nProcedure created.\n\n\nTrigger created.\n\nDisconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production\nWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing optionsCTXSYS.CONTEXT\noracle@oel12102:\/var\/tmp\/ds2\/oracleds2\/ [PROD] \n<\/pre>\n
Ok, now it failed to create the tablespaces but this is fine. As I do not have Oracle Text installed the creation of CTXSYS.CONTEXT indexes failed. In general it looks fine. Did we get the same what we did get in the PostgreSQL instance?:<\/p>\n
\nSQL> select table_name from dba_tables where owner = 'DS2' order by 1;\n\nTABLE_NAME\n--------------------------------------------------------------------------------\nCATEGORIES\nCUSTOMERS\nCUST_HIST\nDERIVEDTABLE1\nINVENTORY\nORDERLINES\nORDERS\nPRODUCTS\nREORDER\n\n9 rows selected.\n\nSQL> select sequence_name from dba_sequences where sequence_owner = 'DS2' order by 1;\n\nSEQUENCE_NAME\n--------------------------------------------------------------------------------\nCUSTOMERID_SEQ\nORDERID_SEQ\n\nSQL> select index_name from dba_indexes where owner = 'DS2' order by 1;\n\nINDEX_NAME\n--------------------------------------------------------------------------------\nIX_CUST_USERNAME\nIX_INV_PROD_ID\nIX_PROD_CATEGORY\nIX_PROD_SPECIAL\nPK_CATEGORIES\nPK_CUSTOMERS\nPK_CUST_HIST\nPK_ORDERLINES\nPK_ORDERS\nPK_PROD_ID\n\n10 rows selected.\n\nSQL> select distinct name from dba_source where owner = 'DS2' order by 1;\n\nNAME\n--------------------------------------------------------------------------------\nBROWSE_BY_ACTOR\nBROWSE_BY_CATEGORY\nBROWSE_BY_TITLE\nDS2_TYPES\nLOGIN\nNEW_CUSTOMER\nPURCHASE\nRESTOCK\n\nSQL> select constraint_name from dba_constraints where owner = 'DS2' and constraint_name not like 'SYS%' order by 1;\n\nCONSTRAINT_NAME\n--------------------------------------------------------------------------------\nFK_CUSTOMERID\nFK_CUST_HIST_CUSTOMERID\nFK_ORDERID\nPK_CATEGORIES\nPK_CUSTOMERS\nPK_ORDERLINES\nPK_ORDERS\nPK_PROD_ID\n\n8 rows selected.\n\n<\/pre>\n
It is not exactly the same but this might be because parts of the sample application are implemented in different ways. We at at least have the same tables, almost, except for the “DERIVEDTABLE1” \ud83d\ude42 I am only interested in the data anyway.<\/p>\n","protected":false},"excerpt":{"rendered":"
In the last post we looked at how to install the “Dell DVD Store Database Test Suite” into a PostgreSQL 9.5.2 database. In this post we’ll do the same with an Oracle database.<\/p>\n","protected":false},"author":29,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[96],"type_dbi":[],"class_list":["post-7571","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","tag-oracle"],"acf":[],"yoast_head":"\nThe (almost) same sample schema for all major relational databases (2) - Oracle - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-2-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The (almost) same sample schema for all major relational databases (2) - Oracle\" \/>\n<meta property=\"og:description\" content=\"In the last post we looked at how to install the “Dell DVD Store Database Test Suite” into a PostgreSQL 9.5.2 database. In this post we’ll do the same with an Oracle database.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-2-oracle\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-04-13T13:32:56+00:00\" \/>\n<meta name=\"author\" content=\"Daniel Westermann\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@westermanndanie\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Daniel Westermann\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"21 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-2-oracle\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-2-oracle\/\"},\"author\":{\"name\":\"Daniel Westermann\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"headline\":\"The (almost) same sample schema for all major relational databases (2) – Oracle\",\"datePublished\":\"2016-04-13T13:32:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-2-oracle\/\"},\"wordCount\":261,\"commentCount\":0,\"keywords\":[\"Oracle\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-2-oracle\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-2-oracle\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-2-oracle\/\",\"name\":\"The (almost) same sample schema for all major relational databases (2) - Oracle - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2016-04-13T13:32:56+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-2-oracle\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-2-oracle\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-2-oracle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The (almost) same sample schema for all major relational databases (2) – Oracle\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\",\"name\":\"Daniel Westermann\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"caption\":\"Daniel Westermann\"},\"description\":\"Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on Oracle and PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC\/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming \u201cTechnology Leader Open Infrastructure\u201d and PostgreSQL expert. \u00a0Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is also a certified PostgreSQL Plus 9.0 Professional and a Postgres Advanced Server 9.4 Professional. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper &\u00a0Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications.\",\"sameAs\":[\"https:\/\/x.com\/westermanndanie\"],\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/daniel-westermann\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"The (almost) same sample schema for all major relational databases (2) - Oracle - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-2-oracle\/","og_locale":"en_US","og_type":"article","og_title":"The (almost) same sample schema for all major relational databases (2) - Oracle","og_description":"In the last post we looked at how to install the “Dell DVD Store Database Test Suite” into a PostgreSQL 9.5.2 database. In this post we’ll do the same with an Oracle database.","og_url":"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-2-oracle\/","og_site_name":"dbi Blog","article_published_time":"2016-04-13T13:32:56+00:00","author":"Daniel Westermann","twitter_card":"summary_large_image","twitter_creator":"@westermanndanie","twitter_misc":{"Written by":"Daniel Westermann","Est. reading time":"21 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-2-oracle\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-2-oracle\/"},"author":{"name":"Daniel Westermann","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"headline":"The (almost) same sample schema for all major relational databases (2) – Oracle","datePublished":"2016-04-13T13:32:56+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-2-oracle\/"},"wordCount":261,"commentCount":0,"keywords":["Oracle"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-2-oracle\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-2-oracle\/","url":"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-2-oracle\/","name":"The (almost) same sample schema for all major relational databases (2) - Oracle - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2016-04-13T13:32:56+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-2-oracle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-2-oracle\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-2-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"The (almost) same sample schema for all major relational databases (2) – Oracle"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66","name":"Daniel Westermann","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","caption":"Daniel Westermann"},"description":"Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on Oracle and PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC\/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming \u201cTechnology Leader Open Infrastructure\u201d and PostgreSQL expert. \u00a0Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is also a certified PostgreSQL Plus 9.0 Professional and a Postgres Advanced Server 9.4 Professional. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper &\u00a0Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications.","sameAs":["https:\/\/x.com\/westermanndanie"],"url":"https:\/\/www.dbi-services.com\/blog\/author\/daniel-westermann\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/7571","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=7571"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/7571\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=7571"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=7571"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=7571"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=7571"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}