My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.