OraFAQ Forum: Server Administration » Columns used for partition

Home » RDBMS Server » Server Administration » Columns used for partition

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Columns used for partition [message #225560]

Tue, 20 March 2007 06:17

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

Hi ,
How to find out which columns are used to partition a table ?

Report message to a moderator

Re: Columns used for partition [message #225561 is a reply to message #225560]

Tue, 20 March 2007 06:22

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SQL> desc DBA_PART_KEY_COLUMNS
 Name                             Null?    Type
 -------------------------------- -------- ----------------------
 OWNER                                     VARCHAR2(30)
 NAME                                      VARCHAR2(30)
 OBJECT_TYPE                               CHAR(5)
 COLUMN_NAME                               VARCHAR2(4000)
 COLUMN_POSITION                           NUMBER

Regards
Michel

Report message to a moderator

Re: Columns used for partition [message #225563 is a reply to message #225560]

Tue, 20 March 2007 06:24

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

Thnx Mike

Report message to a moderator

Previous Topic:	How to Create Database in Oracle 10G Express Edition?
Next Topic:	get DDL in 8i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 15:41:04 CST 2024