Home » RDBMS Server » Server Administration » ORA-01031 when create a MV
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;
|
|
|
|
|
Goto Forum:
Current Time: Mon Jan 13 13:22:31 CST 2025
|