Tech Tip: SQL Script to find group guid fails with ora-01489

Document created by Kip_Lamb Employee on Feb 16, 2017
Version 1Show Document
  • View in full screen mode

TECH TIP - If the above SQL statement fails with error - 'ora-01489 result of string concatenation is too long' you can potentially resolve by adding the desired group type to the where clause.

Typically this is a one of the Business Service groups or a custom group. Find this WHERE in the SQL and add an AND with the type of group you are looking to delete.


WHERE a.entity_type = b.entity_type_id

AND b.entity_class = 'group'

-- Add in line below, replacing 'group_type' with desired type. Example 'business_service'
AND b.entity_type = 'group_type'