ChatGPT said: Is there a way to exclude a specific table from the Shrink LOB segment job?

Hi,

I am not a DBA but using Copilot, I found this answer to your question.  Perhaps this would help?

Please note, this forum is not a DBA forum but specifically for the Astea Alliance line of products for IFS so normally such questions would not be answered here.

Yes, you can exclude a specific table from the Shrink LOB segment job by using the ALTER TABLE command with the SHRINK SPACE option. However, if you want to exclude a particular table from this operation, you would need to ensure that the command is not applied to that table.

One approach is to create a script that performs the SHRINK SPACE operation on all tables except the one you want to exclude. Here's a basic example of how you might do this:

BEGIN
   FOR rec IN (SELECT table_name FROM user_tables WHERE table_name NOT IN ('YOUR_TABLE_TO_EXCLUDE')) LOOP
      EXECUTE IMMEDIATE 'ALTER TABLE ' || rec.table_name || ' SHRINK SPACE';
   END LOOP;
END;

Replace 'YOUR_TABLE_TO_EXCLUDE' with the name of the table you want to exclude. This script will iterate through all tables in the user schema and apply the SHRINK SPACE command to each one, except the specified table.

Yes, it is possible to exclude the shrinking of the CLOB column ACTION_PARAMETERS in the FND_EVENT_ACTION_TAB table. You can achieve this by using the ALTER TABLE command with the SHRINK SPACE option, but specifically targeting only the segments you want to shrink.

Here's an example of how you might do this:

BEGIN
   FOR rec IN (SELECT segment_name FROM dba_segments WHERE segment_name = 'FND_EVENT_ACTION_TAB' AND segment_type = 'TABLE') LOOP
      EXECUTE IMMEDIATE 'ALTER TABLE ' || rec.segment_name || ' SHRINK SPACE CASCADE';
   END LOOP;
END;

This script will shrink the space for the FND_EVENT_ACTION_TAB table but will exclude the ACTION_PARAMETERS CLOB column from the operation.

Hope this helps.

Phil