Re: *** Student requests help with SQL

In article <1998060917221100.NAA19567_at_ladder01.news.aol.com>,   nchan50315_at_aol.com (NChan50315) wrote:
>
> The following information is quoted from the SQL*Pus help file on my Personal
> Oracle 7 for Windows 95 trial version. "To get your own copies of the tables
> (employee, department...), see your DBA or run the Oracle-supplied command
file
> named DEMOBLD (you run this file from your operating system, not from
> SQL*plus). For instructions on how to run DEMOBLD, see the Oracle
installation
> and user's manual provided for your operating system".
This means you should have associated the file ending .sql with Oracle SQL*Plus, the application to run SQL Scripts.
>
> I went to Start/Find and could locate the DEMOBLD.sql in the C:\ORAWIN95\DBS
> directory. I do not have the manuals.
>
> 1. How do I run the file to install the tables. I do not know how to run
the
> file from the operating system.

Invoke SQL*Plus, connect as some defined DB User, issue START <your filename>
> Additional Information: The Developer 2000
> Demos menu has an item called Build Tables. However, I do not know how to get
> it going. When I click on Build Tables, it gives an error (something related
> to SGA).

Guessing here very much: Your Database may be not running. You can start it up via the Administrator Toolbar (it's been some time since I worked with Personal Oracle on Win95, so, just experiment!
>
> 2. How do I open a SQL*DBA session?.
>

SQL*DBA ist still mentioned very often even in the newest Server Documentation. It has been replaced with Server Manager, to be invoked with svrmgr23 from any command prompt.

> Thanks very much. Please forward a copy of the reply to my address. Naveen
>
>

Sorry, message *not* forwarded...

Generally speaking, follow these guidelines: (Assuming you have some database installed via the Oracle Installer)

1.) Assure that your database is up and running
2.) Connect as user SYSTEM using e.g. SQL*Plus (plus33 from command prompt)
3.) Define some user in your database w/CREATE USER ...

    (Oracle Server SQL Language Reference for details) 4.) Connect as the new user
5.) Start the script DEMOBLD.SQL, it generates and populates

    the Tables DEPT, EMP, ...

Hope this helps, rgw

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Jun 10 1998 - 07:01:52 CDT