RE: when an oracle schema created

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

Not every user has his own schema (owns any objects). And, even if he has, the time when schema was created doesn't have to correspond to the time when user was created.

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:41 AM To: vnr1995_at_gmail.com; oracle-l_at_freelists.org Subject: RE: when an oracle schema created

Oops - re-read.

dba_users has the create date of a user.

v$database will have the create date of the instance.

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:51:46 CST