Partiton tables [message #51585] |
Fri, 31 May 2002 21:49 |
Milind S Deobhankar
Messages: 33 Registered: January 2002
|
Member |
|
|
Hi,
I had created range partiton table in the Oracle but by mistake i had deleted the Script file can any body tell me from where i can get all the details of the partion.
I mean to say that in which data dictionary the information about the partition is there.
Milind
|
|
|
Re: Partiton tables [message #51588 is a reply to message #51585] |
Sat, 01 June 2002 00:48 |
Pravin Raharekar
Messages: 18 Registered: April 2002
|
Junior Member |
|
|
Hi,
You can see the details by retriving information from ALL_TAB_PARTITIONS or DBA_TAB_PARTITIONS, which you will find in SYS Schema.
Thanks and Regards
Pravin
|
|
|