ORA-36389: (XSAGPARTDEP01) Can not aggregate from PARTITION
number into PARTITION number due to increasing sparsity
along DIMENSION %J.
- 1 Answers
- 2850 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: The user is attempting to use partitions as a means
of sparsity control, however they have set up their
partitions in a manner that simply makes no sense. It is a
simple fact that during aggregation data becomes more dense,
not less dense, and yet thier partitions indicate the opposite.
Action: Modify the partition template add the specified
dimension into the source composite, or removing it from the
target composite.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-12007: materialized view reuse parameters are inconsistent
ORA-02058: no prepared transaction found with ID string
LSX-00284: duplicate constraint name "~S"
ORA-25179: invalid PCTTHRESHOLD storage option value
ORA-24851: failed to connect to shared subsystem
ORA-01494: invalid SIZE specified
DRG-50911: invalid first document number string
ORA-02347: cannot grant privileges on columns of an object table
ORA-32840: property name cannot be NULL
HI ALL, I AM FACING DATABASE ERROR EXP-00002 IN ORACLE 10G, WIN XP OS. PLS HELP ME TO SOLVE THIS PROBLEM. AM NEW TO DBA ACTIVITIES
IMP-00015: following statement failed because the object already exists:
NCR-04013: NCRR: Insufficient authorization
Oracle Errors 
