Re: user access to create tables

On Wed, 25 Jan 2006 18:49:35 -0800, leshanster wrote:

> I am not teaching...I am actually taking the course, but I happen to be
> a sys admin in the dept. We had a linux box running Oracle 9i, but it
> crashed last semester, so I had to start from scratch and I have no
> experience in setting up a DB server. The only experience I have is
> runny MySQL on a home linux server. So, I am new and there are things
> I just don't know.

Thought that might be a possibility.

Depending on what you want/need in the course, you might want to look at Oracle's new XE product.

Although it has the same core engine as the Standard and Enterprise Editions, the Java related and enterprise management related features have been trimmed. As a result, it's very light weight (150M download, but Linux/WIndows only), ideal (and legally free) for teaching basic transaction processing, SQL and PL/SQL.

If you need more capability, then go for the Enterprise Edition and look at Werner Puschitz' site for good instructions on how to set up, configure the Linux for Oracle, and install Oracle. http://www.puschitz.com

Where are you located? We might be able to hook you up with locals who can help you get off the ground properly.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting [replies] guarantees I won't respond. ***