Change table and Change Tracking tables are created from OEM or the OEE Data Admin tool. SQL restricts all DDL operations on Change table and Change Tracking table and cannot perform DDL operations like ALTER TABLE, DROP TABLE, CREATE TABLE, CREATE INDEX, DROP INDEX, TABLE Rename on the Change table and Change Tracking table. However, some DML operations are allowed for Change table and Change Tracking table. The following table summarizes the operational access of OE SQL to the Change table and Change Tracking table:

Operation Change Table Change Tracking Table
INSERT Not allowed Not allowed
DELETE Allowed Allowed
UPDATE Not allowed Allowed only on “_User-Misc” field. Not allowed on all other fields
SELECT Allowed Allowed
Note: If the source table is a Multi-tenant table, only tenants with access to Multi-tenant tables can access those table for Change data.