Sergei
Check HIGH_VALUE column in DBA_TAB_PARTITIONS and compare it to current
date.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, December 02, 2002 3:48 PM
Hello everybody.
I have a number of
DBA_TAB_PARTITIONS
-Original Message-
Sent: Monday, December 02, 2002 3:49 PM
To: Multiple recipients of list ORACLE-L
Hello everybody.
I have a number of tables with range by date partitions. I need to
write a script to monitor the latest partitions and send me an e-mail if
it's close
Got it
-Original Message-
Neyman
Sent: Monday, December 02, 2002 1:45 PM
To: Multiple recipients of list ORACLE-L
Sergei
Check HIGH_VALUE column in DBA_TAB_PARTITIONS and compare it to current
date.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple
You may use the following query will identify the 'highest' partition by date range.
select partition_name, partition_position , high_value, tablespace_name
from dba_tab_partitions
where table_name = 'table_name'
and table_owner = 'owner'
and partition_position = ( select max(partition_position)