Home » RDBMS Server » Server Administration » Date of table creation
Date of table creation [message #59762] Sun, 21 December 2003 22:05 Go to next message
Harikishan
Messages: 12
Registered: August 2003
Junior Member
Hi
We found few tables in our database which is not of regular databse use. These are created from our admin login. How to find on what date these tables are created.

Regards
Hari

Report message to a moderator

Re: Date of table creation [message #59765 is a reply to message #59762] Sun, 21 December 2003 22:17 Go to previous message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Hi,

Try this:

SELECT owner, object_name, created
FROM dba_objects
WHERE object_type = 'TABLE'
/

Best regards.

Frank

Report message to a moderator

Previous Topic: SCN Generation
Next Topic: background process
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 08:13:53 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.