Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: dumb newbie questions

Re: dumb newbie questions

From: Vincent Ventrone <vav_at_mitre.org>
Date: Thu, 13 May 1999 13:47:05 -0700
Message-ID: <373B3A49.559F9D97@mitre.org>

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 Thompson
Received on Thu May 13 1999 - 15:47:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US