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

From: Louise <louise_mc_dowell_at_hotmail.com-NOSPAM>
Date: Wed, 15 Aug 2001 22:21:07 +0100
Message-ID: <3b7ae851$1_1@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 Wed Aug 15 2001 - 16:21:07 CDT