Re: Noob Oracle Question

CJM wrote:
> Can anyone point me firstly in the direction of some good informations sites
> to tutorial sites where I can find out more?

> I realise that Oracle is significant technology that won't be mastered in a
> day, but I need to start somewhere.
>

Best place to start is with
http://www.oracle.com/pls/db102/homepage?remark=tahiti and start with the documentation on "Getting Started". This will truly give you all the information you require

> I'm required to write a small bolt-on application (web based), so I was
> intending to create a separate 'database', where I could store my
> application's stored procedures/views/etc, so that it would be independant
> from our ERP system.

After reading the "Getting Started" docs I would suggest you store your application stored procedures/views/etc in a different schema in the SAME database as the ERP system (if the vendor will allow it). This will improve performance and is easier to design and make secure. You should however have a test and development environment FAR away from the production environment. It is normally quite easy to create a copy of a database for these purposes. Again this is all in the "Getting Started" section of the documentation. Received on Thu Aug 17 2006 - 04:42:29 CDT