Table created by OS user in oracle

Is there a way to identify the tables created by me in a schema. All of us log in to the same schema and have created lot of objects..as a cleanup i need to identify the tables I have created..

There should be a way to identify it based on the OS USER?

Please let me know..
Thanks
gs79Asked:
Who is Participating?
 
slightwv (䄆 Netminder) Commented:
Not unless you have auditing turned on or have a DDL trigger written.
0
 
sdstuberCommented:
if you have auditing on ,  look in dba_audit_trail

check the os_username  column

if you don't have auditing turned on,  then no you can't derive the history
0
 
gs79Author Commented:
no audit turned on unfortunately..May be I can scan through the tables created in past two months?
0
 
slightwv (䄆 Netminder) Commented:
>>May be I can scan through the tables created in past two months?

Is that a question for us?  If so, I'm not following what you are asking.
0
 
gs79Author Commented:
I think i have to manually scan through all the tables that are created in past few months as there is no way to find out since the audit is not turned on..

I will be splliting the points between sdstuber and slightwv

thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.