Re: Can I get the information When a Schema has been created

Re: Can I get the information When a Schema has been created

 

  

SELECT username, created
FROM dba_users;

Anindya S Gupta wrote:

>Hi,
>Can I find from when a database schema has been created.
>
>Regards,
> Anindya
> "Oracle it's not just a database it's a lifestyle!"
>
>
>
>
>-----Original Message-----
>From: Rubec Tom (xwave)
>[mailto:oracledba-ezmlmshield-x16376091.[Email address protected]
>Sent: Wednesday, March 01, 2006 6:39 PM
>To: LazyDBA Discussion
>Subject: RE: Auto start up of databases
>
>i think thos are set up with oracle install.
>
>you need to edit your oratab file
>/var/opt/oracle/oratab
>or
>/etc/oratab
>could be somewhere else
>
>
>
>-----Original Message-----
>From: nitin
>[mailto:oracledba-ezmlmshield-x59638714.[Email address protected]
>Sent: Monday, February 27, 2006 7:36 AM
>To: LazyDBA Discussion
>Subject: Auto start up of databases
>
>Hi gurus,
>do I need to make any changes to any of the file (like inittab or any
>other file in init.d) when i configure dbstart and dbshut on Solaris? I
>am using 9.2.0.1.
>
>
>Nitin
>
>
>Notice: The information contained in this e-mail message and/or
>attachments to it may contain confidential or privileged information. If
>you are not the intended recipient, any dissemination, use, review,
>distribution, printing or copying of the information contained in this
>e-mail message and/or attachments to it are strictly prohibited. If you
>have received this communication in error, please notify us by reply
>e-mail or telephone and immediately and permanently delete the message
>and any attachments. Thank you
>
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
>see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com By using this list you agree
>to these terms:http://www.lazydba.com/legal.html
>
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these
>terms:http://www.lazydba.com/legal.html
>
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>
>
>

Oracle LazyDBA home page