我建立物化视图的时候报权限不足,报的错误如下:ORA-01031:权限不足我的sql语句如下:
create materialized view mv_monthly_sales
build immediate
refresh on commit
enable query rewrite
as select sale_month, sum(price * quantity) from employee_sale_details group by sale_month就算我用系统账户SYSTEM登录一样是这个错,请解决
create materialized view mv_monthly_sales
build immediate
refresh on commit
enable query rewrite
as select sale_month, sum(price * quantity) from employee_sale_details group by sale_month就算我用系统账户SYSTEM登录一样是这个错,请解决
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货