Re: Are there any sample DBs with content to load ?

On Feb 21, 9:47 pm, peter.s..._at_yahoo.com (Peter Swampton) wrote:
> In order to learn some SQL and PL-SQL statements I need one or more sample
> databases with one or more tables inside.
>
> Ok, I could create the tables and data records manually.
> But this would be very unconvenient. Before I reinvent the wheel
> I could imagine that there is somewhere a sample database to download
> which I can load into my Oracle installation.
>
> Does someone here in the forum know such a sample database ?
>
> Thank you
> Peter

Oracle provides some out of the box: SCOTT schema used in examples throughout the documentation (EMP, DEPT, and a couple of less popular tables,) and some more demo schemas in more recent database releases. You can install SCOTT schema by connecting as SYSDBA and running the following script from SQL*Plus:

@?/rdbms/admin/utlsampl.sql

Other demo schema creation scripts are in $ORACLE_HOME/demo/schema, review README.txt there for installation instructions. Actually, these are created with default Oracle install since 9i so you might already have them.

Regards,

    Vladimir M. Zakharychev
    N-Networks, makers of Dynamic PSP(tm)     http://www.dynamicpsp.com

@?/ Received on Thu Feb 22 2007 - 11:49:45 CST