Re: Noob Oracle Question

CJM wrote:
> I'm usually developing with SQL Server, but our organisation is in the
> process of implementing an ERP system that is Oracle-based (10g).
>
> 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.
>
> I have access to the web-based Enterprise Manager and Oracle SQL Developer,
> though I'm sure I could gain access to or install other tools as required.
>
> My first mission, I guess, is to find out a bit about the fundamentals or
> Oracle. I understand Oracle doesnt have DB as such but has Schemas, but
> which are a slightly different concept. So I'd like to get my head around
> some of these fundamental concepts.
>
> Secondly (and more practically), I need to know how to create my separate
> 'database', and how I can refer to tables & views in the ERP system. In SQL
> this is fairly easy to do - if my application wants to manipulate a table in
> a different DB I simply use the following type of reference: Select * from
> OtherDB.dbo.Table1. I assume there is an Oracle equivalent.
>
> Can anyone point me firstly in the direction of some good informations sites
> to tutorial sites where I can find out more? Can anyone give me a simple
> summary of what I need to do to create this separate 'database' and how I
> get it to interact but its ERP peer DB.
>
> I realise that Oracle is significant technology that won't be mastered in a
> day, but I need to start somewhere.
>
> Thanks in advance

Doc homepage is at

http://www.oracle.com/pls/db102/homepage?remark=tahiti

You'll need a (free and instant) OTN account to read it. Note the 'Getting started' manual located on the first page. The Concepts manual is also a mandatory read.

-- 
Sybrand Bakker
Senior Oracle DBA