Home » SQL & PL/SQL » SQL & PL/SQL » problem in creating Hash Partition
problem in creating Hash Partition [message #284523] Thu, 29 November 2007 23:53 Go to next message
mr.rajeshyadav
Messages: 48
Registered: November 2007
Member
Hi,

when i am trying to create Hash partitions for an existing table with range partitions it is throwing exception can any one help me on this regard
this is the query i am using

CREATE INDEX MAKE_INDEX_VD ON VEHICLE_DETAILS (MAKE_ID)
GLOBAL PARTITION BY HASH (MAKE_ID)
PARTITIONS 4;

for clear discription about the exception please find attached snapshot

Thanks in advance
Rajesh ./fa/3502/0/
  • Attachment: user.bmp
    (Size: 265.41KB, Downloaded 247 times)
Re: problem in creating Hash Partition [message #284533 is a reply to message #284523] Fri, 30 November 2007 00:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"Error at line 6 column 20"
There is no line 6 in your statement.
How could we help you if you don't post the actual statement?

Use SQL*Plus and copy and paste your screen.

Regards
Michel
Re: problem in creating Hash Partition [message #284542 is a reply to message #284533] Fri, 30 November 2007 00:35 Go to previous messageGo to next message
mr.rajeshyadav
Messages: 48
Registered: November 2007
Member
Sorry,

i was running that query in SQLDeveloper thats why it was showing like that now u can find the correct image

This is the query

CREATE INDEX MAKE_INDEX_VD ON VEHICLE_DETAILS (MAKE_ID)
GLOBAL PARTITION BY HASH (MAKE_ID)
PARTITIONS 4;
This is the exception

./fa/3504/0/



Thanks in advance
Rajesh
  • Attachment: user.bmp
    (Size: 265.41KB, Downloaded 236 times)
Re: problem in creating Hash Partition [message #284547 is a reply to message #284542] Fri, 30 November 2007 00:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If I ask you SQL*Plus is that because SQL*Plus put a pointer on the error.
I don't want to count lines and columns.

In addition, pictures can't be download by some readers and are heavier than text.

It's just a syntax error, have a look at the documentation.

Regards
Michel
Re: problem in creating Hash Partition [message #284548 is a reply to message #284547] Fri, 30 November 2007 00:52 Go to previous messageGo to next message
mr.rajeshyadav
Messages: 48
Registered: November 2007
Member
i don't have SQL*plus installed in my machine
if you want me say where it is showing error i will tell you

CREATE INDEX MAKE_INDEX_VD ON VEHICLE_DETAILS (MAKE_ID)
GLOBAL PARTITION BY *HASH (MAKE_ID)
PARTITIONS 4;

in the query i have marked as * there it is showing error i have checked the syntax also that is also correct.

Thanks,
Rajesh.
Re: problem in creating Hash Partition [message #284555 is a reply to message #284548] Fri, 30 November 2007 01:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And your Oracle version is? (at least 3 decimals)

Regards
Michel
Re: problem in creating Hash Partition [message #284558 is a reply to message #284548] Fri, 30 November 2007 01:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It took me less than the time to write this post to see in the SQL Reference that in 9.0 and 9.2 only global partitioning by range is allowed.

If you just did that before posting you got the answer 2.5 hours before and save my time for other more serious questions.

Regards
Michel
Re: problem in creating Hash Partition [message #284560 is a reply to message #284547] Fri, 30 November 2007 01:20 Go to previous message
MarcS
Messages: 312
Registered: March 2007
Location: Antwerp
Senior Member
Michel Cadot wrote on Fri, 30 November 2007 07:44

If I ask you SQL*Plus is that because SQL*Plus put a pointer on the error.
I don't want to count lines and columns.

In addition, pictures can't be download by some readers and are heavier than text.

It's just a syntax error, have a look at the documentation.

Regards
Michel



Michel: you forgot to ask a small but yet important question Wink

Which Oracle Version are we dealing with

EDIT: Never mind Laughing

[Updated on: Fri, 30 November 2007 01:21]

Report message to a moderator

Previous Topic: 3rd maximum salary of an employee query
Next Topic: order by clause
Goto Forum:
  


Current Time: Fri Dec 09 03:41:46 CST 2016

Total time taken to generate the page: 0.06425 seconds