I presume that the SID is one value for the whole database server? If so, when querying my Oracle database, do I have to specify the database name everytime in the query? eg.
Depends who you connect as and how you set up your schema. Do you have a DBA near you, or are you setting this up yourself? If you don't have a DBA, you will need to read through the "Oracle Database Concepts" documentation which can tell you all about users, roles, privileges, schemas, synonyms etc. Otherwise you will find Oracle very hard to use. [ August 30, 2005: Message edited by: Paul Sturrock ]
OK, I will look into the documentation mentioned. However, sounds like if the user account I use has "ownership" of the tables in question, with appropriate privileges, I don't need to specify the table name...?
what if we put solar panels on top of the semi truck trailer? That could power this tiny ad: