Oracle 19c EE on OL 8.3
Working with Database Sample Schemas, and wanting to install the OE sample, went to https://github.com/oracle/db-sample-schemas/releases/latest and downloaded db-sample-schemas-19.2.zip. Unzipped it and read the README.txt.
At first reading it looks like an 'all or nothing' script .. installs all of the sample schemas unconditionally. Oh well, give it a whirl. Make my current directory the 'db-sample-schemas-19.2' that was unzipped from the download. 'Connect to my pluggable pdb01 as SYSTEM and execute mksample.sql.
First error msgs were understandable. Trying to drop schemas that don't yet exist, and trying to create an OS directory that already exists.
Then comes the fun part:
Connected.
SP2-0310: unable to open file "__SUB__CWD__/human_resources/hr_main.sql"
Connected.
SP2-0310: unable to open file "__SUB__CWD__/order_entry/oe_main.sql"
Connected.
SP2-0310: unable to open file "__SUB__CWD__/product_media/pm_main.sql"
Connected.
SP2-0310: unable to open file "__SUB__CWD__/info_exchange/ix_main.sql"
Connected.
SP2-0310: unable to open file "__SUB__CWD__/sales_history/sh_main.sql"
Connected.
SP2-0310: unable to open file "__SUB__CWD__/bus_intelligence/bi_main.sql"
Connected.
not spooling currently
SP2-0310: unable to open file "__SUB__CWD__/mkverify.sql"
Huh? what's with the "__SUB__CWD/" business? Looking into the script itself and that's exactly what it says:
CONNECT system/&&password_system@&&connect_string
SET SHOWMODE OFF
@__SUB__CWD__/human_resources/hr_main.sql &&password_hr &&default_ts &&temp_ts &&password_sys &&logfile_dir &&connect_string
CONNECT system/&&password_system@&&connect_string
SET SHOWMODE OFF
@__SUB__CWD__/order_entry/oe_main.sql &&password_oe &&default_ts &&temp_ts &&password_hr &&password_sys __SUB__CWD__/order_entry/ &&logfile_dir &vrs &&connect_string
So I googled "SUB_CWD" and found a hit at ORACLE-BASE. It said those were place-holders and gave a perl script to edit them.
Going back to the official oracle docs, I found nothing about this. Am I missing something?