Dropping Hash Clusters

You can drop a hash cluster using the DROP CLUSTER statement:

DROP CLUSTER emp_dept;

A table in a hash cluster is dropped using the DROP TABLE statement. The implications of dropping hash clusters and tables in hash clusters are the same as those for dropping index clusters.

See Also:

"Dropping Clusters"

Hide Navigation

Quick Lookup

Database Library · Master Index · Master Glossary · Book List · Data Dictionary · SQL Keywords · Initialization Parameters · Advanced Search · Error Messages

Main Categories

Installation
Getting Started
Administration
Application Development
Grid Computing
High Availability
Data Warehousing
Content Management and Unstructured Data
Information Integration
Security

This Document

Oracle® Database Administrator's Guide 11g Release 2 (11.2)
Getting Started with Database Administration
Creating and Configuring an Oracle Database
Starting Up and Shutting Down
Configuring Automatic Restart of an Oracle Database
Managing Processes
Managing Memory
Managing Users and Securing the Database
Monitoring Database Operations
Managing Diagnostic Data
Managing Oracle Enterprise Manager Database Control
Managing Control Files
Managing the Redo Log
Managing Archived Redo Logs
Managing Tablespaces
Managing Datafiles and Tempfiles
Managing Undo
Using Oracle Managed Files
Managing Schema Objects
Managing Space for Schema Objects
Managing Tables
Managing Indexes
Managing Clusters
Managing Hash Clusters
Managing Views, Sequences, and Synonyms
Repairing Corrupted Data
Managing Automated Database Maintenance Tasks
Managing Resources with Oracle Database Resource Manager
Oracle Scheduler Concepts
Scheduling Jobs with Oracle Scheduler
Administering Oracle Scheduler
Distributed Database Concepts
Managing a Distributed Database
Developing Applications for a Distributed Database System
Distributed Transactions Concepts
Managing Distributed Transactions
Support for DBMS_JOB in Oracle Database 11g Release 2

New and changed documents:

HTML

PDF