| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Re: dumb newbie questions
TwoSheds wrote:
> In the starter database, the docs say the contents consist of User accounts,
> Tablespaces, etc. What it doesn't say is whether there is any data in it.
> Are there any data tables already created, which I can muck around with with
> SQL?
No tables in a new database except the Data Dictionary (the various
tables referenced via views named DBA_<foo>, etc. -- I wouldn't do
*anything* to those -- they are manipulated indirectly using various
DDL, or Data Definition Language, commands like "CREATE TABLE..")
However you can try running a standard SQL script called UTLSAMPL.SQL --
on an NT box it should be in %ORACLE_HOME%\rdbmsNN\admin) This script
will create the (in)famous "SCOTT/TIGER" Oracle userid plus some sample
tables -- if I were you I'd read through the script to see exactly what
it does before executing it...
Good luck
--
Vincent Ventrone
DBA, Dept. R101
vav_at_mitre.org
(781) 271-7048
The MITRE Corp. | "...In my opinion there's nothing M/S C020 | in this world beats a '52 Vincent 202 Burlington Rd. | and a redheaded girl." Bedford, MA 01730 | -- Richard ThompsonReceived on Thu May 13 1999 - 15:47:05 CDT
![]() |
![]() |