Unexpected Oracle Spatial Audit Entries on AUD$ (Doc ID 1338587.1)

Last updated on NOVEMBER 03, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.
Checked for relevance on 23-Apr-2013

Symptoms

You are not using Georaster or Oracle Spatial in your environment yet you are observing audit records being generated for the MDSYS user.

On AUD$ there are entries like these :

...
select sdo_geor_def.isDropColumn(:1) from dual
select sdo_geor_def.getSqlText from dual
update sdo_geor_sysdata_table set GEORASTER_TABLE_NAME=:1 where GEORASTER_TABLE
update mdsys.sdo_tin_pc_sysdata_table set TABLE_NAME=:1 where TABLE_NAME=:2
update mdsys.sdo_tin_pc_seq set TABLE_NAME=:1 where TABLE_NAME=:2 and sdo_owne
delete from sdo_geor_ddl__table$$ where id=2
SELECT topology FROM SDO_TOPO_METADATA_TABLE a,TABLE(a.Topo_Geometry_Layers
insert into sdo_geor_ddl__table$$ values (2)

select sdo_geor_def.getSqlText from dual
SELECT topology FROM SDO_TOPO_METADATA_TABLE a, TABLE(a.Topo_Geometry_Layers
select count(*) from sdo_geor_sysdata_table where sdo_owner=:1 and RDT_TABLE_NAM
insert into sdo_geor_ddl__table$$ values (2)
SELECT COUNT(*) FROM SDO_GEOR_SYSDATA_TABLE WHERE SDO_OWNER = :1 AND GEORASTER_
delete from sdo_geor_ddl__table$$ where id=2



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms