-
How to read table from another tablespace
Hello,
I have created two users (alpha, beta) and two tablespaces (alpha, beta).
I have created a table in beta called OrgData.
When I log in as alpha I would like to be able to write:
SELECT * FROM ORGDATA
This produces an error displaying table not found.
The next statement works but I would like to avoid specifying the tablespace in this case:
SELECT * FROM BETA.ORGDATA.
Is this a tablespace issue? A user issue? Or a schema issue?
If anybody knows please shout.
Thanks.
Regards,
John
-
well its nothing to do with tablespaces, tablespaces are where you store your objects. What you are doing is specifying the schema name of the other table.
So to get what you want, as alpha do
create synonym ORGDATA for beta.orgdata;
then do select * from orgdata; and you will have your data
-
grant select on orgdata to alpha
-
Originally Posted by pando
grant select on orgdata to alpha
i believe that part had already been done when he said
SELECT * FROM BETA.ORGDATA.
worked
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|