Home » SQL & PL/SQL » SQL & PL/SQL » Listing Partitions
Listing Partitions [message #22965] Thu, 07 November 2002 10:49 Go to next message
Rizwan Qazi
Messages: 135
Registered: August 2002
Senior Member
Is there any view or table in oracle which lists the partitions based on table name - something like cols gives a record of all the columns and which table they belong to in the database

Regards,

Riz

Report message to a moderator

Re: Listing Partitions [message #22967 is a reply to message #22965] Thu, 07 November 2002 12:17 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
user_tab_partitions

Report message to a moderator

Previous Topic: NO_DATA_FOUND in Cursor with a Select into
Next Topic: Re: Is there such a thing as a recursive query??
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Apr 29 08:34:43 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.