Oracle Database Discussions

Hi Gurus

I working here as an apps DBA and dont have sys dba privilges on databases.

I have two databases prod and dev with same schema name on both the databases,now i have to create one view on dev which exist on prob.
such as
CREATE OR REPLACE VIEW XXX_DDF
(TABLESPACE_NAME, BYTES)
AS
SELECT tablespace_name
,sum(bytes) BYTES
FROM dba_data_files
GROUP BY tablespace_name
UNION ALL
SELECT tablespace_name
,sum(bytes) BYTES
FROM dba_temp_files
GROUP BY tablespace_name
/

This script successfully executed on prod but on dev its showing Error :-> Insufficient privilges.
When i checked on both schema's privilges on prod and dev so its same

One thing here i can able to select below but not able create view.....

SELECT tablespace_name
,sum(bytes) BYTES
FROM dba_data_files
GROUP BY tablespace_name
UNION ALL
SELECT tablespace_name
,sum(bytes) BYTES
FROM dba_temp_files
GROUP BY tablespace_name
/

Thanks a lot

GRB