From just looking at the code it seems that upon creating or dropping types or attriutes dynamic SQL is being executed which creates, drops or alters tables. (And some more DDL even...)
Look at the log file and try to locate procs from packages/acs-content-repository/sql/oracle/content-type.sql
