Home » RDBMS Server » Server Administration » table partitioning
table partitioning [message #216382] Fri, 26 January 2007 23:45 Go to next message
nani_ar
Messages: 58
Registered: March 2006
Member
Hi all,

I just want some clarification regarding the table partitioning in oracle8i/9i. We have the feature of partitioning the table. Do we need any oracle license to use it or else we can use it straight away..Ours is in Enterprise Edition.


All the replies are welcome

nani
Re: table partitioning [message #216383 is a reply to message #216382] Fri, 26 January 2007 23:49 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

.

[Updated on: Sat, 27 January 2007 00:45]

Report message to a moderator

Re: table partitioning [message #216385 is a reply to message #216383] Fri, 26 January 2007 23:56 Go to previous messageGo to next message
nani_ar
Messages: 58
Registered: March 2006
Member
Hi taj,

tx for the reply...but some of our friends online are telling that we need a license....which is true...i just cant come to conclusion....


plz clarify

nani
Re: table partitioning [message #216387 is a reply to message #216383] Sat, 27 January 2007 00:06 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
user52 wrote on Sat, 27 January 2007 00:49
Hi,
feature of partitioning the table
It is come with Oracle Software. you have no need to any kind of license of use partitioning.


That is absolutely incorrect.

@OP...you should check Options and search for Partitioning. Although the documentation is for 10g, it still pertains to 8i/9i. Just because Partitioning can be installed does NOT mean you are licensed to use it.
Re: table partitioning [message #216389 is a reply to message #216385] Sat, 27 January 2007 00:08 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

.

[Updated on: Sat, 27 January 2007 00:45]

Report message to a moderator

Re: table partitioning [message #216390 is a reply to message #216389] Sat, 27 January 2007 00:16 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
user52 wrote on Sat, 27 January 2007 01:08

it is option of oracle 9i enterprise edition.
still no need for partitioning.
or


That's correct, it's an OPTION which in Oracle speak means a pay for item. Whether the OP needs partitioning is immaterial, BUT if he decides to use the partitioning option, then he better have a license for it.
Re: table partitioning [message #216391 is a reply to message #216390] Sat, 27 January 2007 00:18 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
For Table Partitioning option we need to separate license ?


regards
Taj

[Updated on: Sat, 27 January 2007 00:46]

Report message to a moderator

Re: table partitioning [message #216392 is a reply to message #216391] Sat, 27 January 2007 00:23 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
user52 wrote on Sat, 27 January 2007 01:18

For Table Partitioning option we need to separate license.


If this is a question, then the answer is as indicated above...YES.
Re: table partitioning [message #216393 is a reply to message #216392] Sat, 27 January 2007 00:44 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Thank You.


regards
Taj
Re: table partitioning [message #216577 is a reply to message #216393] Mon, 29 January 2007 08:45 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
Don't quote me on this, but I thought I remember hearing that in 10g, you no longer needed a license for Partitioning.
Re: table partitioning [message #216593 is a reply to message #216577] Mon, 29 January 2007 10:42 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
I wish that were the case 10g Licensing has Partitioning listed as an Option and therefore a cost item.
Previous Topic: TNS:protocol adapter error
Next Topic: Mail sending
Goto Forum:
  


Current Time: Sun Dec 04 22:47:59 CST 2016

Total time taken to generate the page: 0.12273 seconds