>CREATE PUBLIC SYNONYM MyTable FOR SCHEMA.MyTable
>
>The MyTable synonym MUST be unique in the entire Oracle database across all schemas. So if Schema1 has a MyTable1 and Schema2 has a MyTable1, a MyTable1 public synonym can only point to one of them.
Every example I looked at uses no schema prefixes - they just connect and fire away at select * from customers. So how are they doing this? Would this be a database that only has a single (default schema) then? But that can't be it either since they are uysually using sample data...
Is there no equivalent of
USE
The above Create Synonym would be a major hassle as you'd have to do this for each table. Is this a per connection thing or a permanent admin thing?
>Each user can have a set of their own [private] synonyms that can point to any table in the Oracle database as long as that user has SELECT privs on the table. These synonyms only have to be unique to that User's ID.
>
>Usually, the Oracle DBA will limit your ability to create a public synonym as this could screw up existing synonyms.
>
>>The terminology of Oracle is really getting me here. Schema is what would be the equivalent of a SQL Server database?
>
>Kind of. A schema is really just a [generic] User ID created for a specific app to be the owner of all the objects, including tables, created under that ID. The biggest difference is all of this is contained under the Oracle instance and can not be "detached" from the instance and "attached" to another Oracle instance. You have to perform an export function to get a "dump" file of all the objects and data. Then you can import that file into another instance of Oracle as long as any Roles defined in the original instance already exist in the new instance.
This really sounds like big fun. THey really did a great job on usability on that one <g>...
I have problems with everything in the admin module. Can't create a new instance - it doesn't accept my passwords even though they are valid. Can't figure out how to add a new 'schema'...
I can see why Oracle is such an expensive solution and kept that way on purpose...
+++ Rick ---
