oracle-samples / db-sample-schemas Goto Github PK

Oracle is getting SRs on these being installed in an EBS Applications system.
I believe providing a warning here would be the best. So...

WARNING: Do not install the Oracle Samples into the same database as Oracle EBS Applications 12.2.x system.

              These sample schema objects are not edition defined and will cause errors during adop patching process.

              If these objects are installed in an EBS 11.5.10.2 or 12.1.3 system, they should be removed before upgrading to 
              12.2.x.
                    
              If you want to use these open and modify these sample scripts to use a different set of schemas.
              EXAMPLE: scott_hr,  scott_oe,  etc...

README file suggests SQLcl or SQLPlus can be used to load schemas. However the sales_history schema relies on the LOAD command which is only available in SQLcl. If you use SQLPlus, the install appears to work, but the final verification step shows that several of the tables are empty.

When I installed HR sample schema via sqlplus on Windows server, I did following steps to avoid errors.

• session configuration
  alter session set "_ORACLE_SCRIPT"=true;
• password quate with ""

If this information is helpful, could you add Readme note.

Or if it already exists, please tell me the link.