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: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 16 Aug 2001 11:11:25 +0100
Message-ID: <3b7b9c4d$0$227$ed9e5944@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 - 05:11:25 CDT

Original text of this message

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