Grant privileges on v_$sysstat
"dist cash" <mccdba@hotma To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> il.com> cc: Sent by: Subject: RE: [Q] wield create view error, need help? root@fatcity. com October 24, 2002 04:14 PM Please respond to ORACLE-L Thank you for your help. I follow your instruction and granr privilege. It fixed me a lot of errors. Currently, I have another problem still create view problem. SQL> CREATE OR REPLACE VIEW WWV_DBA_SGA ( COMPONENT_GROUP, 2 MEMORY_SIZE_IN_BYTES ) AS select name component_group, bytes memory_size_in_bytes from v$sgastat 3 . SQL> / MEMORY_SIZE_IN_BYTES ) AS select name component_group, bytes memory_size_in_bytes from v$sgastat * ERROR at line 2: ORA-00942: table or view does not exist I tried to grant privilege and got error: SQL> grant select on sys.v$sgastat to portal30; grant select on sys.v$sgastat to portal30 * ERROR at line 1: ORA-02030: can only select from fixed tables/views Do you have ideal how to fix this problem? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).