Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


ORA-36389: (XSAGPARTDEP01) Can not aggregate from PARTITION
number into PARTITION number due to increasing sparsity
along DIMENSION %J.



ORA-36389: (XSAGPARTDEP01) Can not aggregate from PARTITION number into PARTITION number due to inc..

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

Post New Answer

More Oracle Errors Interview Questions

ORA-14279: index mismatch for tables in ALTER TABLE EXCHANGE SUBPARTITION

2 Answers  


ORA-07455: estimated execution time (string secs), exceeds limit (string secs)

1 Answers  


ORA-39003: unable to get count of total workers alive

1 Answers  


PCC-00105: Keyword WORK required here by ANSI

1 Answers  


ORA-06977: X.25 Driver: X.25 Level 2 failure

1 Answers  


ORA-03235: max # extents (string) reached in table string.string subpartition string

1 Answers  


LFI-00117: Unable to rename file.

1 Answers  


PLS-00650: invalid type for PARTITION/CLUSTER/ORDER BY clause

1 Answers  


ORA-14111: creation of a GLOBAL partitioned index on clustered tables is not supported

1 Answers  


NZE-28844: No wallet present

1 Answers  


ORA-16711: the resource guard index is out of bounds

1 Answers  


PCB-00230: Indicator table size must not be less than its host variable

1 Answers  


Categories