Home » SQL & PL/SQL » SQL & PL/SQL » Find Tables Creation Date & Machine Name
Find Tables Creation Date & Machine Name [message #427695] Sat, 24 October 2009 02:13 Go to next message
skkazmi
Messages: 44
Registered: April 2006
Member
Hi All,

Is their any option to find out the complete table information like their creation date, machine name, system IP at the time of table created etc.

Thanking You,
Khurram Kazmi.
Re: Find Tables Creation Date & Machine Name [message #427702 is a reply to message #427695] Sat, 24 October 2009 02:58 Go to previous messageGo to next message
Michel Cadot
Messages: 63808
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No unless you activated audit.

Regards
Michel
Re: Find Tables Creation Date & Machine Name [message #427739 is a reply to message #427695] Sat, 24 October 2009 11:35 Go to previous messageGo to next message
binary_bandor
Messages: 2
Registered: June 2009
Junior Member
u can use this query...

select * from all_objects
where object_type='TABLE';

Regards
binary_bandor
Re: Find Tables Creation Date & Machine Name [message #427741 is a reply to message #427739] Sat, 24 October 2009 11:36 Go to previous message
Michel Cadot
Messages: 63808
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How does this give machine name, IP...?

Regards
Michel
Previous Topic: How to sort it.
Next Topic: how to know all system defined table names
Goto Forum:
  


Current Time: Wed Sep 28 21:11:56 CDT 2016

Total time taken to generate the page: 0.10816 seconds