RE: Senior moment
- From: <Joel.Patterson@xxxxxxxxxxx>
- To: <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>, <tomday2@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 7 Dec 2006 11:01:57 -0500
Senior moments... I did not read the rest of the email.... To see you
were trying to create a materialized view.
Joel Patterson
Database Administrator
joel.patterson@xxxxxxxxxxx
x72546
904 727-2546
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mercadante, Thomas F
(LABOR)
Sent: Thursday, December 07, 2006 11:00 AM
To: tomday2@xxxxxxxxx; Oracle-L Freelists
Subject: RE: Senior moment
Thomas,
You need to grant access to the table directly to the second user rather
than through the ROLE. You are creating a PL/SQL package against the
table. You must have direct access to it - not inherited thru the role.
Tom
________________________________
This transmission may contain confidential, proprietary, or privileged
information which is intended solely for use by the individual or entity
to whom it is addressed. If you are not the intended recipient, you are
hereby notified that any disclosure, dissemination, copying or
distribution of this transmission or its attachments is strictly
prohibited. In addition, unauthorized access to this transmission may
violate federal or State law, including the Electronic Communications
Privacy Act of 1985. If you have received this transmission in error,
please notify the sender immediately by return e-mail and delete the
transmission and its attachments.
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Thomas Day
Sent: Thursday, December 07, 2006 10:33 AM
To: Oracle-L Freelists
Subject: Senior moment
Oracle 9.2 on AIX
I've created a table (table a) under one schema with a public synonym
and granted select to a role.
In another schema, with that role, I've created another schema. I can
select count(*) from table a in this second schema but when I try to
create a foreign key or a materialized view log I get -
ORA-00942: table or view does not exist
I'm sure that I'm missing something obvious, I just can't think what it
is. All suggestions welcome.
------------------------------------------------------------------------
-----------
SQL> CREATE MATERIALIZED VIEW LOG ON ADDRESS_CDS tablespace dss_DATA
2 WITH SEQUENCE(
3 ADC_DESC
4 ,ADC_CLOSE_DT
5 ) INCLUDING NEW VALUES
6 /
CREATE MATERIALIZED VIEW LOG ON ADDRESS_CDS tablespace dss_DATA
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> desc ADDRESS_CDS
Name
Null? Type
------------------------------------------------------------------------
-------- -----------------
ADC_CD
NOT NULL VARCHAR2(2)
ADC_DESC
NOT NULL VARCHAR2(80)
ADC_CLOSE_DT
DATE
SQL> select count(*) from ADDRESS_CDS;
COUNT(*)
----------
0
Other related posts:
