So, where is the script for building the SCOTT schema?
Back in the day it was part of the SQL*Plus build:
$ORACLE_HOME/sqlplus/demo/demobld.sql
(or something, I'm doing this from memory). But in 11gR2 there are no demo scripts in the sqlplus sub-directory. This was also probably the case in 10g but I never had occasion to look for it on that platform. Anyway, in 11gR2 its location is $ORACLE_HOME/admin/rdbms/utlsampl.sql
.
Presumably Oracle have obscured it because they want everybody to stop using SCOTT and standardise on the modern samples. But this schema is part of the Oracle heritage. It should have Grade II listed status.
No comments:
Post a Comment