Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Security on Table WRI$_OPTSTAT_HISTGRM_HISTORY

mpatzwahlJul 9 2024

Hi,

i would like to move this Table as SYS to another Tablespace (sysaux_scratch )

I got a ORA-01031: insufficient privileges

desc WRI$_OPTSTAT_HISTGRM_HISTORY

Name            Null?    Typ                         
--------------- -------- --------------------------- 
OBJ#            NOT NULL NUMBER                      
INTCOL#         NOT NULL NUMBER                      
SAVTIME                  TIMESTAMP(6) WITH TIME ZONE 
BUCKET          NOT NULL NUMBER                      
ENDPOINT        NOT NULL NUMBER                      
EPVALUE                  VARCHAR2(1000)              
COLNAME                  VARCHAR2(128)               
EP_REPEAT_COUNT NOT NULL NUMBER                      
EPVALUE_RAW              RAW(1000 BYTE)              
SAVTIME_DATE             DATE                        
SPARE1                   NUMBER                      
SPARE2                   NUMBER                      
SPARE3                   NUMBER                      
SPARE4                   VARCHAR2(1000)              
SPARE5                   VARCHAR2(1000)              
SPARE6                   TIMESTAMP(6) WITH TIME ZONE 
ENDPOINT_ENC             RAW(1000 BYTE)

select count(colname) from WRI$_OPTSTAT_HISTGRM_HISTORY;

=>0

select count(epvalue) from WRI$_OPTSTAT_HISTGRM_HISTORY

=> ORA-01031

Can i disable this security feature ?

or is there one alternative to reorg the table ?

Thanks,

Marco

Comments
Post Details
Added on Jul 9 2024
4 comments
420 views