在oracle schema中，有没有一种方法可以将表的创建和列修改与执行者一起记录在表中？

CREATE TABLE schema_audit (
    operation_type VARCHAR2(10),
    operation_time TIMESTAMP,
    operation_user VARCHAR2(30),
    table_name VARCHAR2(30),
    column_name VARCHAR2(30)
);

CREATE OR REPLACE TRIGGER schema_audit_trigger
AFTER CREATE OR ALTER ON SCHEMA
DECLARE
    v_operation_type VARCHAR2(10);
    v_operation_time TIMESTAMP;
    v_operation_user VARCHAR2(30);
    v_table_name VARCHAR2(30);
    v_column_name VARCHAR2(30);
BEGIN
    -- 获取操作类型
    v_operation_type := CASE
        WHEN ORA_DICT_OBJ_TYPE = 'TABLE' THEN 'CREATE'
        WHEN ORA_DICT_OBJ_TYPE = 'TABLE PARTITION' THEN 'ALTER'
        WHEN ORA_DICT_OBJ_TYPE = 'TABLE SUBPARTITION' THEN 'ALTER'
        ELSE NULL
    END;

    -- 获取操作时间
    v_operation_time := SYSTIMESTAMP;

    -- 获取操作者用户名
    v_operation_user := SYS_CONTEXT('USERENV', 'SESSION_USER');

    -- 获取表名和列名
    v_table_name := ORA_DICT_OBJ_NAME;
    v_column_name := ORA_DICT_OBJ_SUBNAME;

    -- 将操作信息插入到记录表中
    INSERT INTO schema_audit (
        operation_type,
        operation_time,
        operation_user,
        table_name,
        column_name
    ) VALUES (
        v_operation_type,
        v_operation_time,
        v_operation_user,
        v_table_name,
        v_column_name
    );
END;