partition [message #336337] |
Fri, 25 July 2008 14:37  |
shoaib123
Messages: 118 Registered: December 2007 Location: Chicago
|
Senior Member |
|
|
Is there anyway, can we check from any data dictionary table, the time when the partition got created on any table.
Thanks in advance
|
|
|
|
Re: partition [message #336342 is a reply to message #336338] |
Fri, 25 July 2008 14:48   |
shoaib123
Messages: 118 Registered: December 2007 Location: Chicago
|
Senior Member |
|
|
Sorry.. i will read it again, buti am not sure which point i missed.
But Thanks and apprecaite your help.
|
|
|
|
Re: partition [message #336347 is a reply to message #336344] |
Fri, 25 July 2008 15:03   |
shoaib123
Messages: 118 Registered: December 2007 Location: Chicago
|
Senior Member |
|
|
Release 9.2.0.1.0 & Window operating system..
I don't have prviliges to see any dba_objects tables. I am unable to see the partition information on all_objects table.Even though table containing parititions.
|
|
|
|
|
Re: partition [message #336354 is a reply to message #336350] |
Fri, 25 July 2008 15:23   |
shoaib123
Messages: 118 Registered: December 2007 Location: Chicago
|
Senior Member |
|
|
Window Professional 2004 and oracle Release 9.2.0.1.0
>I am unable to see the partition information on all_objects table
select distinct(object_type) from all_objects
CONSUMER GROUP
DIRECTORY
EVALUATION CONTEXT
FUNCTION
INDEXTYPE
JAVA CLASS
JAVA RESOURCE
LIBRARY
OPERATOR
PACKAGE
PROCEDURE
SEQUENCE
SYNONYM
TABLE
TYPE
VIEW
No information for parititions.. Although table is partitions in database..
select table_name, partition_name from all_tab_partitions
table_name Partition_name
AB_TYPES P20080315
AROLE_DTL P20080625
AB_USER P20080625
AB_ADJ P20080625
AB_ADJ_COLUMNS P20080625
AT_BATCH_CODE_LU P20080625
AT_BATCH_PYMT P20080625
> I don't have priviliges to see any dba tables.
Thanks for you valuable time and help.
[Updated on: Fri, 25 July 2008 15:38] Report message to a moderator
|
|
|
|
Re: partition [message #336445 is a reply to message #336337] |
Sat, 26 July 2008 18:11   |
Lynn T
Messages: 8 Registered: July 2008
|
Junior Member |
|
|
Maybe this will help you do a bit of research: I listed all the tables that you have access to (USER), and mention partitions. Then I got a list of date fields contained in them. None of them look to me like they mention partition creation though.
1 SELECT TABLE_NAME, COLUMN_NAME
2 FROM ALL_TAB_COLUMNS
3 WHERE TABLE_NAME IN
4 (
5 select table_name
6 from all_tab_columns
7 where column_name like '%PART%'
8 AND TABLE_NAME LIKE 'USER%'
9 )
10* AND DATA_TYPE = 'DATE'
TABLE_NAME COLUMN_NAME
------------------------------ -----------------
USER_ALL_TABLES LAST_ANALYZED
USER_EXPFIL_PREDTAB_PLAN TIMESTAMP
USER_INDEXES LAST_ANALYZED
USER_IND_PARTITIONS LAST_ANALYZED
USER_IND_STATISTICS LAST_ANALYZED
USER_IND_SUBPARTITIONS LAST_ANALYZED
USER_OBJECT_TABLES LAST_ANALYZED
USER_PART_COL_STATISTICS LAST_ANALYZED
USER_SQLSET_PLANS TIMESTAMP
USER_SQLTUNE_PLANS TIMESTAMP
USER_SUBPART_COL_STATISTICS LAST_ANALYZED
USER_TABLES LAST_ANALYZED
USER_TAB_MODIFICATIONS TIMESTAMP
USER_TAB_PARTITIONS LAST_ANALYZED
USER_TAB_STATISTICS LAST_ANALYZED
USER_TAB_SUBPARTITIONS LAST_ANALYZED
16 rows selected.
|
|
|
|
|