Re: Creating Scott/Tiger
Thanks to Scott and everyone else who replied. You'd think I'd have known how to create the scott schema, but I haven't created it in years and I'd forgotten where the script was located. Someone at Oracle recently sent me some demo scripts that make use of the scott tables, and that's why my question. Jonathan Gennick --- Brighten the corner where you are mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com On Fri, 30 Aug 2002 09:38:33 -0800, Scott wrote: >I don't know about the user scott/tiger, but the scripts to build the tables >(emp, dept, etc) are in $ORACLE_HOME/sqlplus/demo > >/opt/oracle/product/9.0.2/sqlplus/demo> ll >total 16 >-rw-r--r-- 1 oracle oinstall 3565 May 13 2001 demobld.sql >-rw-r--r-- 1 oracle oinstall 573 May 13 2001 demodrop.sql > >Scott Shafer >San Antonio, TX >210.581.6217 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Creating Scott/Tiger
Title: RE: Creating Scott/Tiger The why not run the SCOTT.sql script in the RDBMS\admin directory. That's the script to just create scott, and the table emp, dept and salgrade with their data. That's the original script If I remember correctly. Sorry for coming into the convo so late. -Original Message- From: Freeman, Robert [mailto:[EMAIL PROTECTED]] Sent: Friday, August 30, 2002 4:43 PM To: Multiple recipients of list ORACLE-L Subject: RE: Creating Scott/Tiger There are differences in the two scripts as I recall. The sqlplus demo scripts do not build the scott account, and only build the basic dept, emp tables with some data. The utlsampl.sql script is much more encompassing, creating users scott, adams, jones, clark and blake, granting privs, creating tables with pk's and fk's. Much more complete. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -Original Message- Sent: Friday, August 30, 2002 2:14 PM To: Multiple recipients of list ORACLE-L Hi Jonathan > I need to create the Scott/Tiger schema in Oracle9i. Does anyone > recall off the top of their head just where the script to do this is > located? The creation script can usually be found in ${ORACLE_HOME}/sqlplus/demo/demobld.sql Regards Dale -- Need instant schema documentation? Check out the DDL to HTML generator in the free DataBee DBATool. http://www.DataBee.com/dt_home.htm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Creating Scott/Tiger
There are differences in the two scripts as I recall. The sqlplus demo scripts do not build the scott account, and only build the basic dept, emp tables with some data. The utlsampl.sql script is much more encompassing, creating users scott, adams, jones, clark and blake, granting privs, creating tables with pk's and fk's. Much more complete. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -Original Message- Sent: Friday, August 30, 2002 2:14 PM To: Multiple recipients of list ORACLE-L Hi Jonathan > I need to create the Scott/Tiger schema in Oracle9i. Does anyone > recall off the top of their head just where the script to do this is > located? The creation script can usually be found in ${ORACLE_HOME}/sqlplus/demo/demobld.sql Regards Dale -- Need instant schema documentation? Check out the DDL to HTML generator in the free DataBee DBATool. http://www.DataBee.com/dt_home.htm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Creating Scott/Tiger
Hi Jonathan > I need to create the Scott/Tiger schema in Oracle9i. Does anyone > recall off the top of their head just where the script to do this is > located? The creation script can usually be found in ${ORACLE_HOME}/sqlplus/demo/demobld.sql Regards Dale -- Need instant schema documentation? Check out the DDL to HTML generator in the free DataBee DBATool. http://www.DataBee.com/dt_home.htm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Creating Scott/Tiger
$ORACLE_HOME/rdbms/admin/utlsampl.sql Jonathan Gennick <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/30/2002 09:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Creating Scott/Tiger I need to create the Scott/Tiger schema in Oracle9i. Does anyone recall off the top of their head just where the script to do this is located? Jonathan Gennick --- Brighten the corner where you are mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Creating Scott/Tiger
I don't know about the user scott/tiger, but the scripts to build the tables (emp, dept, etc) are in $ORACLE_HOME/sqlplus/demo /opt/oracle/product/9.0.2/sqlplus/demo> ll total 16 -rw-r--r-- 1 oracle oinstall 3565 May 13 2001 demobld.sql -rw-r--r-- 1 oracle oinstall 573 May 13 2001 demodrop.sql Scott Shafer San Antonio, TX 210.581.6217 > -Original Message- > From: Jonathan Gennick [SMTP:[EMAIL PROTECTED]] > Sent: Friday, August 30, 2002 11:53 AM > To: Multiple recipients of list ORACLE-L > Subject: Creating Scott/Tiger > > I need to create the Scott/Tiger schema in Oracle9i. Does anyone > recall off the top of their head just where the script to do this is > located? > > Jonathan Gennick --- Brighten the corner where you are > mailto:[EMAIL PROTECTED] * 906.387.1698 > http://Gennick.com * http://MichiganWaterfalls.com * > http://ValleySpur.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jonathan Gennick > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Creating Scott/Tiger
Hi Genninck, 9i and 8i $ORACLE_HOME/rdbms/admin/utlsampl.sql Alessandro Guimarães - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, August 30, 2002 9:53 AM I need to create the Scott/Tiger schema in Oracle9i. Does anyone recall off the top of their head just where the script to do this is located? Jonathan Gennick --- Brighten the corner where you are mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alessandro Guimaraes INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Creating Scott/Tiger
I need to create the Scott/Tiger schema in Oracle9i. Does anyone recall off the top of their head just where the script to do this is located? Jonathan Gennick --- Brighten the corner where you are mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).