I am using Oracle 8.1.7.
I need to do 2 things for EVERY user table in the database:

1. Create ddl for a copy of each table ( a shadow table), with the additonal column of a unique ID. This is not a data copy, just copy the metadata (columns, index, etc).

2. Create a trigger, so that when the base table is changed, the entire row is copied to the shadow (Audit) table.

Anyone have any code handy for this in Oracle?

Thanks in advance.