View Single Post

   
  #2 (permalink)  
Old 04-08-2008, 11:08 AM
bernard (bernard_at_bosvark.com)
 
Posts: n/a
Default 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.

Reply With Quote