A
MUSIC schema scripts can be found from a simple menu on my website at the following URL, along with many other goodies including my resume.
http://www.oracledbaexpert.com/oracle/OracleSQLJumpstartWithExamples/index.html.
A.1 MUSICMASTER.SQL
SET ECHO OFFUNDEF DBNAMEPROMPT WHAT IS THE DATABASE OR NETWORK NAME? (SUCH AS: ORADB10)ACCEPT DBNAMEPROMPT CONNECTING TO SYSTEM NOW.CONNECT SYSTEM@&&DBNAME@CREATEUSER.SQLCONNECT MUSIC/MUSIC@&&DBNAME@SCHEMAOLTP.SQL@SEQUENCES.SQL@INSTRUMENT.SQL@ARTIST.SQL@GENRE.SQL;@MUSICCD.SQL@SONGANDTRACK.SQL@GUESTARTIST.SQL@STUDIOTIME.SQL@UPDATEDATA.SQL@CHECKDATA.SQL@SCHEMADW.SQL@DIMENSIONS.SQL@FACTS.SQLEXIT;
A.2 CREATEUSER.SQL
SPOOL log/CREATEUSER.LOG;DROP USER MUSIC CASCADE;CREATE USER MUSIC IDENTIFIED BY MUSICDEFAULT ...
Get Oracle SQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
