DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2000
    Hi guys,
    I require to know the date on which the partition was created. This info is required , so that on the 3rd day i can make it as 'read-only' and on the 60th day 'to drop it'.All of it to run as a cron job.
    I went through most of the relevent tables/views but none seem to have this information.
    can some one help me where to get this information?

  2. #2
    Join Date
    Nov 1999
    Elbert, Colorado, USA
    Unfortunately, I don't have any partitioned tables handy to trace this out explicitly.
    However, it looks to me like your best bet for a creation date is the CREATED column in DBA_OBJECTS. You should be able to join this with DBA_SEGMENTS, which has columns segment_name and partition_name.
    Sorry I can't take this farther for you right now.

  3. #3
    Join Date
    Oct 2000
    thanks, carp
    i will take it from here on.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.