RE: when an oracle schema created

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Thu, 2 Nov 2006 11:47:54 -0500
Message-ID: <F4C27E77F7A33E4CA98C19A9DC6722A2016120B0@EXCHANGE.corp.perceptron.com>

No info on schema creation.
But you can get CREATED in USER_OBJECTS for individual objects in the schema.
Get MIN(CREATED) for specific OWNER - that'll be your time of schema creation.

V$database has nothing to do with the schema (except, schema can not be created prior to the database -:)

Igor

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Smith, Steven K - MSHA
Sent: Thursday, November 02, 2006 11:39 AM To: vnr1995_at_gmail.com; oracle-l_at_freelists.org Subject: RE: when an oracle schema created

v$database

Steve Smith
Envision Technology Partners / MSHA MSIS Team Desk: 303-231-5499

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of vnr1995 Sent: Thursday, November 02, 2006 9:36 AM To: oracle-l_at_freelists.org
Subject: when an oracle schema created

Is there any view that contains information about when a particular schema created?

Thanks,
Ven.
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu Nov 02 2006 - 10:47:54 CST