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