| Drop a hash partition [message #312632] |
Wed, 09 April 2008 08:45  |
chintu00
Messages: 15
Registered: February 2007
Location: Tampa FLorida |
Junior 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: 15243
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
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]
|
|
|
| Re: Drop a hash partition [message #312643 is a reply to message #312636 ] |
Wed, 09 April 2008 09:14 |
chintu00
Messages: 15
Registered: February 2007
Location: Tampa FLorida |
Junior Member |
|
|
Michel, Pls give me the statement.
Thanks
|
|
|
|
| Re: Drop a hash partition [message #312842 is a reply to message #312664 ] |
Wed, 09 April 2008 21:53 |
chintu00
Messages: 15
Registered: February 2007
Location: Tampa FLorida |
Junior Member |
|
|
The link did not help are you able to paste the DDL statement.
Thanks
|
|
|
| Re: Drop a hash partition [message #312848 is a reply to message #312842 ] |
Wed, 09 April 2008 22:24 |
rleishman
Messages: 2563
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 #313098 is a reply to message #312848 ] |
Thu, 10 April 2008 12:24 |
chintu00
Messages: 15
Registered: February 2007
Location: Tampa FLorida |
Junior Member |
|
|
|
Thanks I appreciate it, I found the statement.
|
|
|
]
Members
Search
Help
Register
Login
Home
