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 ]
You don't need to use username before the table name, if you are accessing as a user who owns tables.
Joined: Aug 09, 2005
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...?