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.
The starting point is exactly the same. Download the generic “ds21.tar.gz” and the vendor specific “ds21_oracle.tar.gz” files and transfer both to the node the hosts the Oracle database:
Once extracted we have almost the same structure as in the last post for PostgreSQL:
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:
Lets go:
Looks fine so lets try to load (for Oracle a separate load script was generated):
Hm. Quotas seem to be missing. The script that creates the user is this one:
Lets add the quotas for the tablespaces there:
… and try again (sorry for the long output, just want to be complete here):
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?:
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″ 
I am only interested in the data anyway.
Cet article The (almost) same sample schema for all major relational databases (2) – Oracle est apparu en premier sur Blog dbi services.