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 Tue Oct 22 2002 - 13:29:13 CDT
