Home » RDBMS Server » Server Administration » Columns used for partition
Columns used for partition [message #225560] Tue, 20 March 2007 06:17 Go to next message
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 ?
Re: Columns used for partition [message #225561 is a reply to message #225560] Tue, 20 March 2007 06:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Columns used for partition [message #225563 is a reply to message #225560] Tue, 20 March 2007 06:24 Go to previous message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Thnx Mike
Previous Topic: How to Create Database in Oracle 10G Express Edition?
Next Topic: get DDL in 8i
Goto Forum:
  


Current Time: Sun Dec 04 10:56:24 CST 2016

Total time taken to generate the page: 0.03847 seconds