Home » SQL & PL/SQL » SQL & PL/SQL » partitions
icon7.gif  partitions [message #186357] Mon, 07 August 2006 12:20 Go to next message
kesarla
Messages: 3
Registered: August 2006
Junior Member
How to find the existing partitions on a table? I am kind of new may be this is a dumb question but helps me. Thanks
Re: partitions [message #186392 is a reply to message #186357] Mon, 07 August 2006 15:23 Go to previous messageGo to next message
joy_division
Messages: 4643
Registered: February 2005
Location: East Coast USA
Senior Member
Take a look at USER_TAB_PARTITIONS or DBA_TAB_PARTITIONS.
Re: partitions [message #186394 is a reply to message #186392] Mon, 07 August 2006 15:29 Go to previous message
kesarla
Messages: 3
Registered: August 2006
Junior Member
Thanks,

Cool
Previous Topic: timestamp datatype
Next Topic: ORA-00939: too many arguments for function
Goto Forum:
  


Current Time: Fri Dec 09 09:51:03 CST 2016

Total time taken to generate the page: 0.12230 seconds