ORA-28659: COMPRESS must be specified at object level first



ORA-28659: COMPRESS must be specified at object level first..

Answer / guest

Cause: Attempt to specify COMPRESS at partition level
without first specifying at the table level

Action: Specify COMPRESS at table level. Use ALTER TABLE xxx
MODIFY DEFAULT ATTRIBUTES COMPRESS ...

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-06746: backup cancelled because all files were skipped

1 Answers  


ORA-09794: szrbuild: length of role name is greater than buffer.

1 Answers  


ORA-23377: bad name string for missing_rows_oname1 argument

1 Answers  


IMP-00400: Warning: Object type "string"."string" already exists with a different typeid

1 Answers  


ORA-30342: referenced level is not defined in this dimension

1 Answers  






ORA-22344: can not specify CONVERT TO SUBSTITUTABLE option for ALTER TYPE other than NOT FINAL change

1 Answers  


ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified

1 Answers  


DRG-11600: URL store: string has permanently moved

1 Answers  


ORA-01154: database busy. Open, close, mount, and dismount not allowed now

1 Answers  


DRG-50852: failed to turn SQL trace on

1 Answers  


IMG-00581: output format does not support the specified contentFormat

1 Answers  


ORA-26668: STREAMS process string exists

1 Answers  


Categories