| Drop a hash partition [message #312632] |
Wed, 09 April 2008 08:45  |
chintu00
Messages: 91
Registered: February 2007
Location: NJ, US
|
Member |
|
|
Is there a different way to drop a hash partion than range and list. I tried the folllowing statement and also along with few other options but couldn't get it working.
alter table table_name drop partition partition_name.
|
|
|
|
|
|
| Re: Drop a hash partition [message #312636 is a reply to message #312632] |
Wed, 09 April 2008 08:53  |
 |
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
From doc, ALTER TABLE statement:
| Quote: | Restrictions on Dropping Table Partitions Dropping table partitions is subject to the following restrictions:
You cannot drop a partition of a hash-partitioned table. Instead, use the coalesce_table_partition clause.
...
|
Regards
Michel
[Updated on: Wed, 09 April 2008 08:54] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: Drop a hash partition [message #312848 is a reply to message #312842] |
Wed, 09 April 2008 22:24 |
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
|
Senior Member |
|
|
| chintu00 wrote on Thu, 10 April 2008 12:53 | The link did not help are you able to paste the DDL statement.
|
How hard did you look?
Go to the link specified by Michel.
You will see a page showing links to documentation for different versions of the database. Choose the version that you are using and follow that link.
Depending on which version you choose, you will get a different screen. Here's where you need to use some initiative. Somewhere on that page will be a link to a SQL Reference manual. Find it. Click it.
Once you have opened the SQL Reference, go to the Contents - it should take you there automatically. Find the chapters that deal with SQL STATEMENTS; there are lots so they are divided up alphabetically. Go to the chapter covering ALTER TABLE.
There's the syntax.
Alternatively, that first screen you see when you select your Oracle version may contain a "Quick Search" dialog. Search on "ALTER TABLE".
Ross Leishman
P.S. Practice your research skills. Forum regulars are not very tolerant of people unwilling to help themselves. And rightly so: their time is far more valuable to them than yours.
|
|
|
|
|
|
|
|
|
|
| Re: Drop a hash partition [message #649761 is a reply to message #649759] |
Tue, 05 April 2016 08:41 |
|
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
OK you are able to repeat a solution given 8 years ago but are you able to at least feedback if not thank people who help you in your previous topic?
What I can see is you are not able to read the link I gave you and format your statement.
[Updated on: Tue, 05 April 2016 08:41] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
