OraFAQ Forum: SQL & PL/SQL » Sharing column for partitions.

Home » SQL & PL/SQL » SQL & PL/SQL » Sharing column for partitions.

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

Sharing column for partitions. [message #611501]

Thu, 03 April 2014 03:18

Alexey.Samoilov
Messages: 11
Registered: April 2014

Junior Member

How can I knew by what column partitions were shared?

Report message to a moderator

Re: Sharing column for partitions. [message #611504 is a reply to message #611501]

Thu, 03 April 2014 03:20

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Shared? What do you mean?

Report message to a moderator

Re: Sharing column for partitions. [message #611505 is a reply to message #611501]

Thu, 03 April 2014 03:23

Alexey.Samoilov
Messages: 11
Registered: April 2014

Junior Member

For example,

partition by range(time_key)

How can i SELECT column 'time_key'?

Report message to a moderator

Re: Sharing column for partitions. [message #611508 is a reply to message #611505]

Thu, 03 April 2014 03:26

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

select time_key from mytable;

What is your issue? Clarify.

Report message to a moderator

Re: Sharing column for partitions. [message #611511 is a reply to message #611508]

Thu, 03 April 2014 03:31

Alexey.Samoilov
Messages: 11
Registered: April 2014

Junior Member

I want to know column on which partitions are divided.
For example
partitions are devided by time_key,
subpartitions are devided by market_key

Report message to a moderator

Re: Sharing column for partitions. [message #611512 is a reply to message #611511]

Thu, 03 April 2014 03:34

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

You mean this view? dba_part_key_columns

Report message to a moderator

Re: Sharing column for partitions. [message #611513 is a reply to message #611512]

Thu, 03 April 2014 03:43

Alexey.Samoilov
Messages: 11
Registered: April 2014

Junior Member

Yes,thanks a lot. And for subpartitions dba_subpart_key_columns

Report message to a moderator

Previous Topic:	Unable to get running total conditionally
Next Topic:	before insert & instead OF INSERT trigger

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 04:59:39 CDT 2024