scott user [message #288107] |
Fri, 14 December 2007 19:03 |
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 #288312 is a reply to message #288144] |
Mon, 17 December 2007 01:05 |
|
Maaher
Messages: 7065 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 |
|
Littlefoot
Messages: 21821 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
|
|
|
|
|
|
|
|
|