SQL Logging

From: HRM <hrm_at_dontsendmemail.com>
Date: Tue, 2 Apr 2002 10:51:23 -0600
Message-ID: <a8cnid$dn4$1@canopus.cc.umanitoba.ca>

Does anyone know (or can point me to documentation) how SQL Logging in Oracle 8i works?

I need to log DDL changes done to various databases. SQL Logging captures the DDL statements in a file and can save that file but what I would like to be able to know if this data is stored in a table somewhere that I could query myself, and pull out only the SQL and the DB Name so that I can save changes to specific databases in their own separate file.

Any ideas?

Thanks a lot. Received on Tue Apr 02 2002 - 10:51:23 CST