Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is their any Query to check when tablespace is created.

584159Sep 22 2008 — edited Sep 22 2008
Hi,

i started my Career few months back so i wanted to know this type os basic questions please help me.

Is their any SQL Query to check when tablespace is created and last modified date of that particular
tablespace.

and also how to check when a schema is lastly modified and also which objects are lastly modifed and
if schema is locked then how to check when schema is locked by whom and date.

Regards,
Srinivas.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 20 2008
Added on Sep 22 2008
4 comments
468 views