ORA-01031 when create a MV [message #373348] |
Wed, 11 April 2001 22:53 |
James
Messages: 120 Registered: June 2000
|
Senior Member |
|
|
I am developing a OLAP system,
I want to create a MV as following description:
------------------------------------------------------------------------
Create Materialized View t_ba_mc_week
TABLESPACE USERS PARALLEL NOLOGGING
BUILD IMMEDIATE REFRESH COMPLETE ENABLE QUERY REWRITE
AS select
T.WEEK_ID AS F_WEEK,
SUM(F.CusReg )
FROM CTPFCT_T_BA_MC F, CTPDIM_Time T
WHERE
F.DAY_ID=T.DAY_ID
GROUP BY
T.WEEK_id;
The out put of sqlplus is :
F.DAY_ID=T.DAY_ID
*
ERROR at line 9:
ORA-01031: insufficient privileges
The relating table was created as following:
CREATE TABLE SCOTT.CTPDIM_Time
Day_ID, week_ID¡
CREATE TABLE SCOTT.CTPFCT_T_BA_MC(
DAY_ID VARCHAR2(50) NOT NULL,
City_ID VARCHAR2(50) NOT NULL ,
¡¡¡¡..
I was useing the ¡®scott¡¯ account which was granded 'connect' & 'DBA' Role and 'Unlimited tablespace' system privileges;
|
|
|
Re: ORA-01031 when create a MV [message #373350 is a reply to message #373348] |
Thu, 12 April 2001 00:14 |
Naresh Sharma
Messages: 12 Registered: April 2001
|
Junior Member |
|
|
Hi,
This means that you have insufficient privileges.
Query USER_SYS_PRIVS table to find out whether you have privileges to create a Materialised View.
(SELECT * FROM USER_SYS_PRIVS ).
This table will list down all the Privileges that
you own.
----------------------------------
HTH
Naresh
|
|
|
|