Oracle Solution for Error ora-33413

ORA-33413: (EIFMAKEF01) You cannot export compressed composite workspace object

because one of its bases has limited status or a PERMIT READ restriction.

What triggered the Error:

Export of a compressed composite to an EIF file or lob failed because one or more of the bases had some values that were not in the current status. This can be caused either by a LIMIT command or a PERMIT READ restriction on the dimension.

What should we do to fix it:

Either set the base dimensions' statuses to ALL and remove their PERMIT READ programs, or export using the NOAGGR keyword.