Yep - I stand corrected. It is easy to interchange the two terms if you are not careful - and I was not careful. Steve Smith Envision Technology Partners / MSHA MSIS Team Desk: 303-231-5499 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Powell, Mark D Sent: Thursday, November 02, 2006 10:05 AM To: oracle-l@xxxxxxxxxxxxx Subject: RE: when an oracle schema created I think Steve was a little hasty in his correction and as I have been once or twice was a little sloppy with his terminology. V$database has the create time of the database, while v$instance has the start_time of the instance. Being that an instance is re-created on startup this time is normally different from the database create time. The terms database and instance are often interchanged, but there are times when the difference in the two terms is important. -- Mark D Powell -- Phone (313) 592-5148 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Smith, Steven K - MSHA Sent: Thursday, November 02, 2006 11:41 AM To: vnr1995@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of vnr1995 Sent: Thursday, November 02, 2006 9:36 AM To: oracle-l@xxxxxxxxxxxxx Subject: when an oracle schema created Is there any view that contains information about when a particular schema created? Thanks, Ven. -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l