Re: Creating a tablespace alias?

You are right - I was confusing things. There is a set of code I am modifying in a data-mart that accesses tables (many times) from multiple accounts (not tablespaces). In another account/schema (my own), I want to test the code by hitting test versions of those tables. I can create a synonym for another user's table in my account, but I can't create a synonym for a table in my account that "looks" like another user's table. So my example should have been as follows: Another user has a table that the code refers to as USER1.MAINTABLE. My account has access to that table, but when I run the code and it references USER1.MAINTABLE, I want it to really hit MYUSER.TESTTABLE. Thanks for the correcting my misuse of tablespace.

-Tyler

"Terry Dykstra" <dontreply_tddykstra_at_forestoil.ca> wrote in message news:ZNgt9.49183$ER5.3355175_at_news2.telusplanet.net...
> I think you are confusing things here. The prefix before the tablename is
> the owner ( schema) of that table. It doesn't matter in what tablespace
the
> table is located. Under your account you can create a synonym to point to
> your test table:
> create synonym "SHAREDSPACE.MAINTABLE" for MYSPACE.TESTTABLE
>
> --
> Terry Dykstra
> Canadian Forest Oil Ltd.
> "Tyler Allbritton" <tyler.allbritton_at_ams.com> wrote in message
> news:3db5944d_at_news.ams.com...
> > All,
> > I am trying to test some PL/SQL code that explicitly references a
> > tablespace table (e.g. SHAREDSPACE.MAINTABLE). I don't want my code to
hit
> > the table during the test, I want it to hit my test table (e.g.
> > MYSPACE.TESTTABLE). Is there any way to create an alias for a
tablespace?
> In
> > other words, can I create an alias in my account called
> > SHAREDSPACE.MAINTABLE that points to MYSPACE.TESTTABLE? Thanks in
advance
> > for your help.
> >
> > -Tyler
> >
> >
>
>
Received on Wed Oct 23 2002 - 07:03:16 CDT