ORA-10656: Table is in unusable state due to incomplete operation
Cause: ALTER TABLE SHRINK operation was tried on the table which is in unusable state because of previously failed/incomplete operation.
Action: If the previous operation was

- DROP COLUMN, resubmit DROP COLUMN CONTINUE

- DROP TABLE, resubmit DROP TABLE <table> PURGE

ORA-10657
Custom Search


More Oracle errors
ORA-31084error while creating table "string"."string" for element "string"
ORA-03009Incompatible OCI function call
DRG-50301server error reading request queue
LSX-00134attribute "~1S" has invalid qualification "~2S"
DRG-50920part of phrase not itself a phrase or equivalence
ORA-13539invalid input for modify baseline window size (string, string)
ORA-15470VDBG process terminated with error
QSM-01133query has an ADT column
NCR-01005NCRS: Failed to flush the output buffer.
ORA-08401invalid compiler name: string
ORA-12687Credentials expired.
ORA-23361materialized view "string" does not exist at master site
EXP-00058Password Verify Function for string profile does not exist
LPX-00006invalid child type for parent node
ORA-22868table with LOBs contains segments in different tablespaces
ORA-14622Value string already exists in subpartition string
ORA-19322An error occurred while reading from host (string): port (string)
ORA-30191missing argument list
ORA-13379invalid index for sub-element to be extracted
ORA-31020The operation is not allowed, Reason: string




TOP 20 Oracle errors
ORA-12504TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
RMAN-20079full resync from primary database is not done
ORA-14411The DDL cannot be run concurrently with other DDLs
ORA-14760ADD PARTITION is not permitted on Interval partitioned objects
ORA-10877error signaled in parallel recovery slave string
ORA-32701Hang detected
ORA-00838Specified value of MEMORY_TARGET is too small, needs to be at least stringM
ORA-16665timeout waiting for the result from a database
ORA-16957SQL Analyze time limit interrupt
ORA-16664unable to receive the result from a database
ORA-00000normal, successful completion
RMAN-08132WARNING: cannot update recovery area reclaimable file list
ORA-16766Redo Apply is stopped
ORA-00837Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
RMAN-08137WARNING: archived log not deleted as it is still needed
DIA-48122error with opening the ADR block file [string] [string]
ORA-47988password should contain at least one numeric and one alphabetic character
IMP-00057Warning: Dump file may not contain data of all partitions of this table
ORA-00001unique constraint (string.string) violated
ORA-55508Invalid input to Flashback Transaction Backout




Your own TOP 20 Oracle errors
ORA-10656Table is in unusable state due to incomplete operation