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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Where are the sample tables??? in ORACLE8i

Re: Where are the sample tables??? in ORACLE8i

From: Louise <louise_mc_dowell_at_hotmail.com-NOSPAM>
Date: Thu, 16 Aug 2001 12:55:37 +0100
Message-ID: <3b7bb4f2_2@mk-nntp-1.news.uk.worldonline.com>


well .... I only know I had it in an earlier version .....and it was VERY convenient.

where can I get one of these sql navigators??? ..... It was o0n the oracle cd itself ... I haven't installed any 3rd party tool.

How can I drop/delete a complete database ?????

Louise

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3b7b9c4d$0$227$ed9e5944_at_reading.news.pipex.net...
> I believe that you are thinking of either sql worksheet or possibly dba
> studio?
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> "Louise" <louise_mc_dowell_at_hotmail.com-NOSPAM> wrote in message
> news:3b7ae851$1_1_at_mk-nntp-1.news.uk.worldonline.com...
> > found the script and created some ....
> >
> > TABLE_NAME
> > ----------------------------
> > ACCOUNT
> > BONUS
> > DEPT
> > EMP
> > RECEIPT
> > SALGRADE
> >
> > that looks more familiar .... but I can remeber there was a GUI to see
> these
> > tables and columns and even the data (I think) in a more windowy version
> ..
> > not ONLY via SQL
> >
> > Louise
> >
> > "Gina" <louise_mc_dowell_at_hotmail.com-NOSPAM> wrote in message
> > news:3b7adc85_1_at_mk-nntp-1.news.uk.worldonline.com...
> > > some of the 48 tables I get when I type in
> > >
> > > SELECT TABLE_NAME FROM USER_TABLES;
> > >
> > > DEF$_PROPAGATOR
> > > DEF$_PUSHED_TRANSACTION
> > > DEF$_TEMP$LOB
> > > REPCAT$_AUDIT_ATTRIBUTE
> > > REPCAT$_AUDIT_COLUMN
> > > REPCAT$_COLUMN_GROUP
> > > REPCAT$_CONFLICT
> > > REPCAT$_DDL
> > > REPCAT$_FLAVORS
> > > REPCAT$_FLAVOR_OBJECTS
> > >
> > > TABLE_NAME
> > > -----------------------
> > > REPCAT$_GENERATED
> > > REPCAT$_GROUPED_COLUMN
> > > REPCAT$_KEY_COLUMNS
> > > REPCAT$_OBJECT_PARMS
> > > REPCAT$_PARAMETER_COLUM
> > > REPCAT$_PRIORITY
> > > REPCAT$_PRIORITY_GROUP
> > > REPCAT$_REFRESH_TEMPLAT
> > > REPCAT$_REPCAT
> > > REPCAT$_REPCATLOG
> > > REPCAT$_REPCOLUMN
> > > REPCAT$_REPGROUP_PRIVS
> > > REPCAT$_REPOBJECT
> > > REPCAT$_REPPROP
> > > REPCAT$_REPSCHEMA
> > > REPCAT$_RESOLUTION
> > > REPCAT$_RESOLUTION_METH
> > > REPCAT$_RESOLUTION_STAT
> > > REPCAT$_RESOL_STATS_CON
> > > REPCAT$_RUNTIME_PARMS
> > > REPCAT$_SNAPGROUP
> > >
> > > TABLE_NAME
> > > -----------------------
> > > REPCAT$_TEMPLATE_OBJECT
> > > REPCAT$_TEMPLATE_PARMS
> > > REPCAT$_TEMPLATE_SITES
> > > REPCAT$_USER_AUTHORIZAT
> > > REPCAT$_USER_PARM_VALUE
> > >
> > >
> > > the EMP table where all the examples should be are missing all
together
> > >
> > > which sql-script can I execute to get these example tables and to get
> rid
> > of
> > > the two DBs installed previously .... named SampleDB and ORA
> > >
> > > Louise
> > >
> > >
> >
> >
>
>
Received on Thu Aug 16 2001 - 06:55:37 CDT

Original text of this message

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