Home » SQL & PL/SQL » SQL & PL/SQL » scott user
scott user [message #288107] Fri, 14 December 2007 19:03 Go to next message
aztech
Messages: 1
Registered: December 2007
Junior Member
Sorry if this has been posted already. But has scott schema been removed from 10g Express edition? I tried select * from all_users; and select * from dba_users; Scott isn't showing up. Is scott fired?

[Updated on: Fri, 14 December 2007 19:10]

Report message to a moderator

Re: scott user [message #288108 is a reply to message #288107] Fri, 14 December 2007 19:14 Go to previous messageGo to next message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
Visit http://otn.oracle.com & download the companion CD
SCOTT & other demo schemas are on it.
Re: scott user [message #288144 is a reply to message #288107] Sat, 15 December 2007 01:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Creation script is $ORACLE_HOME/rdbms/admin/scott.sql or $ORACLE_HOME/sqlplus/demo/demobld.sql

Regards
Michel
Re: scott user [message #288312 is a reply to message #288144] Mon, 17 December 2007 01:05 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
You should have the HR schema. It is a slightly more elaborated SCOTT variant. But if you're looking for the original emp/dept of scott, you can search for my posts and the keyword demobld. I've posted them here once.

MHE

[Updated on: Mon, 17 December 2007 01:06]

Report message to a moderator

Re: scott user [message #288321 is a reply to message #288312] Mon, 17 December 2007 01:25 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Here it is:
--
-- Copyright (c) Oracle Corporation 1988, 2000.  All Rights Reserved.
--
-- NAME
--   demobld.sql
--
-- DESCRIPTION
--   This script creates the SQL*Plus demonstration tables in the
--   current schema.  It should be STARTed by each user wishing to
--   access the tables.  To remove the tables use the demodrop.sql
--   script.
--
--  USAGE
--    From within SQL*Plus, enter:
--        START demobld.sql

...



[Obviously, copyrighted information should not be posted that way. I spologize for being that sloppy]

[Updated on: Mon, 17 December 2007 04:13]

Report message to a moderator

Re: scott user [message #288323 is a reply to message #288321] Mon, 17 December 2007 01:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

Copyright (c) Oracle Corporation 1988, 2000. All Rights Reserved.

I don't think it is legal to post copyrighted document from Oracle.

Regards
Michel
Re: scott user [message #288362 is a reply to message #288323] Mon, 17 December 2007 04:25 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Thank you, Michel.

However, I believe that such a script should not be protected by copyright. Not that it is exactly a public domain material, but practically every single soul who has ever worked with Oracle had it, used it and should be able to recreate it when there's a need to do that. What rights are being violated? CREATE TABLE statements (which are far too simple; they don't even contain any constraints!)? Data about dozen imaginary employees?

I'd understand if there were "Terms of Use" or something, but copyright? Oh well ...

Finally, these scripts are available for download so - where's the purpose of a copyright? If I were Scott the cat, I'd let people use my tables.
Re: scott user [message #288368 is a reply to message #288362] Mon, 17 December 2007 04:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is just like a book (any book).
It is published, you can read it, you can use its content but you can't post/copy part of it (more than a paragraph).

I agree with you scott schema is used everywhere in Oracle world, it is well-known, it is free, but still copyrighted until Oracle remove its comment from the header.

Note that usually I removed the content of the post but didn't do it here. The reason is that Oracle never claimed its property on it and sued someone for this. So it can be seen as it tolerate this use.

Regards
Michel
Re: scott user [message #288373 is a reply to message #288368] Mon, 17 December 2007 04:56 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Confused If it is indeed copyrighted perhaps I should remove my uploaded files to and point to here instead.

MHE

[Updated on: Mon, 17 December 2007 04:56]

Report message to a moderator

Re: scott user [message #288385 is a reply to message #288373] Mon, 17 December 2007 05:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is a good idea to replace the content by the link even more when you see that a couple of bugs are fixed in the online script (the use of to_date function and correct data format).

Regards
Michel

Re: scott user [message #288387 is a reply to message #288385] Mon, 17 December 2007 05:34 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Granted. Will do.

MHE
Previous Topic: Pls. suggest the better way to select rows in this scenario
Next Topic: regional language
Goto Forum:
  


Current Time: Sat Dec 03 20:21:38 CST 2016

Total time taken to generate the page: 0.22863 seconds