Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: few basic questions

Re: few basic questions

From: Brian Peasland <dba_at_remove_spam.peasland.com>
Date: Thu, 12 Feb 2004 18:59:39 GMT
Message-ID: <402BCD1B.D6B178A8@remove_spam.peasland.com>


> When using the oracle client on win2k, what is the tool that you can type
> SQL commands into. I remember there were two, one was better than the other.

Use SQL*Plus. SQLWorksheet is the other product, but inferior, IMO.  

> When youre starting a new project, what do you create your tables in...is it
> a "database" or a "project"? you know, the thing a DBA would set up for you
> and tell you the user/pass for.

A "schema". Your objects should be in their own schema, accessed by the userid/password.  

> On the client. is tnsnames.ora the only thing you have to configure?

That and SQLNET.ORA as well.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"
Received on Thu Feb 12 2004 - 12:59:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US