Re: Sample database

From: Van Messner <vmessner_at_bestweb.net>
Date: Wed, 21 May 2003 20:15:51 -0400
Message-ID: <vco5on9ahqp5d4@corp.supernews.com>

Yes, either use 9i which ships with the HR and other sample schemas or do what Hans said. There's a great Oracle DBA book by Tom Kyte in which he uses a similar technique to create tables of whatever size are necessary.

Van

"Hans Forbrich" <forbrich_at_telusplanet.net> wrote in message news:3ECBCF7A.C223F48D_at_telusplanet.net...
> Peter Morris wrote:
>
> > Is there a sample Oracle database I can download,
> > I want to practise things like configuration, backup,
> > etc. Say, about 30 tables, plus indexes, stored procedures,
> > triggers and so on. Maybe 50 MB or so.
> >
> > TIA
>
> Easy enough to create your own for the data-volume part of it.
>
> The data dictionary is fairly big - create a couple of tables like the
> DBA_xxx views, with an added key, then repeatedly add copies of the
> selected views setting the key based on row number.
>
>
>
Received on Wed May 21 2003 - 19:15:51 CDT