Problem solveGet help with specific problems with your technologies, process and projects.

Last DDL time by tablespace

There are times when one may need to know when the last DDL was performed on a particular tablespace. Here's how.

Share this item with your network:

By

Database Person

Published: 28 Aug 2002

There are times when one may need to know when the last DDL was performed on a particular tablespace. Here's how to find out. The code is saved in a file called last_ddl.sql. At the SQL Prompt the user enters:

SQL> @last_ddl

The user should have SELECT privileges on DBA_OBJECTS and DBA_SEGMENTS. This script has been tested on Oracle versions 7.3.4.5 and 8.1.7. Here is the code:

Start the conversation

0 comments

Register

I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.

Please check the box if you want to proceed.

I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.