Re: Oracle newbie: HELP

Ok, A short summary of my pain.

Each database runs as a NT service.
Each database that you create will need a SID which is a unique identifier. The default is ORCL.

A datafile is the physical file that Oracle stores stuff in. Oracle accesses the datafile through a tablespace which is the logical representation.
A tablespace can have more than one datafile.

In Oracle each user is a database schema, ie they can have their own tables triggers, indexes and more.
Each user has a default tablespace where he/she store their objects.

the NET8 connect string is what the DSN is to ODBC. setup up a NET8 through the Net8 Easy Config. the wizard will ask you for a name - choose a name choose TCP/IP
type in your server name and port (default port is 1521) You can test the connection by using the SYSTEM account pwd = MANAGER

In SQL*PLUS you can say
connect USER/PASSWORD_at_SERVICENAME; where service name is the NET8 name that you created earlier.

Setting up ODBC you would create a DSN pointing to your NET8 service name

Hope this helps and let me know if you need any more help

Filip
fhanik_at_digitalworkforce.net

<billy_collins_at_my-deja.com> wrote in message news:7lgd94$lmv$1_at_nnrp1.deja.com...
> Hello all,
>
> I am a perl programmer, who wants to upgrade from mySql to Oracle
> databases. I got myself a trial version of the server/client software
> on NT and have installed it.
>
> But now, how do I start? I read their extensive documentation
> painstakingly, but they have SO MUCH information, IN SO MANY PLACEs
> that I have no clue where to start!
>
> I would like to start by writing a simple script that connects to an
> Oracle database thru ODBC and displays a table. Thats all I want to
> do, but when I try to start the Net8 (which I believe is the thing to
> start with) I don't know -- it asks me for
>
>
> 1. Net8 Connect String
> 2. Account Name
> 3. Account Password
>
> I would really appreciate if someone could tell me if there is a
> default setting. I remember my friend telling me there is "Scott/Tiger"
> or something but that doesn;t work. And in any case, since I dont know
> the net8 connect string I cannot even be sure if Scott/tiger works!
>
> I have read 2 books, but neither of them discusses this. They directyly
> start with RDBMS concepts and SQL Plus!!!
>
> PLEASE help!!!
>
> Thanks
> Billy
>
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Thu Jul 01 1999 - 15:39:16 CDT