Re: newbie default tablespace

Originally posted by Fred Flintstone
> I'm a newbie in oracle.
> How can I do to modify this sql statament
>
> SELECT * FROM DB1.TABLE1;
> with
> SELECT * FROM TABLE1;
>
> I change the user Default Tablespace but this isn't the solution.
>
> Excuse me but I don't know well Oracle Enterprise Manager.
>
> help me please
> tnx

You must be from SqlServer world.

DB1 is neither a tablespace name nor it is a separate database. In Oracle DB1 is the schema/user who owns TABLE1. If you have select grant on TABLE1 from DB1 then you must prefix table name with DB1 in your query.

Alternately, you could create a synonym.

For help on synonym syntax, goto http://tahiti.oracle.com.

Regards
/Rauf Sarwar

--
Posted via http://dbforums.com