Re: Finding all tables that were created 2 we

Since you already know about sys.dba_objects and its last_dd_timel column then you are probably having a problem finding a match on the date. Try something like:

column object_name format a30
select object_name, last_ddl-time

from sys.dba_objects
where object_type = 'TABLE'
and last_ddl_time < sysdate - 14

I am at home so I can not syntax/stupidity check this, but if it does not work e-mail me, and I will dial in to work, write the query, and cut and paste it into a reply. I have done similiar queries many times. Note that it will narrow the result set if you can provide "and object_name like 'some_string%' "
Mark Powell -- The only advise that counts is the advise that you follow so follow your own advise Received on Thu Mar 20 1997 - 00:00:00 CST