ORA-36260: (XSAGHIERPART00) Aggregating from partition %J to partition %J over hierarchy workspace object creates an increase in sparsity.
Cause: In the partition creation / aggmap creation a situation developed such that when aggregating over a particular dimension of the aggmap a partition boundary was crossed such that the sparsity of the target partition included dimensions that were not in the sparsity of the source partition. Since the process of aggregation always densifies rather than sparsifying this is an extremely suboptimal design and it is not supported by the aggregate system.
Action: Set up your partitioning such that for any partition boundary the source and target partitions of the aggregation will always move towards denser partitions. For any child (c) and any parent (p) where (c) and (p) are in different partitions it must be the case that the parent partition contains no dimension in the composite that the child partition does not contain in its composite.
ORA-36261
Custom Search


More Oracle errors
ORA-56723I/O request limit exceeded - session terminated
ORA-22059buffer size [string] is too small - [string] is needed
ORA-29808specified primary operator binding does not exist
ORA-29363plan directive string, string is mandatory and cannot be modified or deleted
ORA-12814only one CACHE or NOCACHE clause may be specified
ORA-13356adjacent points in a geometry are redundant
SQL*Loader-00940UPI error while setting NCHAR bind attributes for column string table string
ORA-31530could not find published column string for CDC subscriber view string.string
EVM-00019Failed to read event from input stream
NNL-00282Cancelled restart
ORA-12532TNS:invalid argument
ORA-24338statement handle not executed
ORA-29513referenced class name too long
RMAN-00564host data too long
NNL-01002NOT AUTHORITY responses received: number
ORA-26089LONG column "string" must be specified last
ORA-10900extent manager fault insertion event #string
QSM-02029PL/SQL function invocation
ORA-02141invalid OFFLINE option
ORA-13630The task string contains execution results and cannot be executed.




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
RMAN-08132WARNING: cannot update recovery area reclaimable file list
ORA-00000normal, successful completion
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-36260(XSAGHIERPART00) Aggregating from partition %J to partition %J over hierarchy workspace object creates an increase in sparsity.