Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Wednesday, November 5, 2008

OATM doesn't drop some seeded tablespaces

During our OATM migration, we found that fndtsmig.pl did not drop some seeded tablespaces which were empty:

  1  select segment_type,segment_name
  2  from dba_segments
  3  where tablespace_name in
  4  (
  5  'ZXX',
  6  'ZXD',
  7  'ZPBX',
  8  'ZPBD',
  9  'XLEX',
 10  'XLED',
 11  'MSTX',
 12  'MSTD',
 13  'LNSX',
 14  'LNSD',
 15  'IZUX',
 16  'IZUD',
 17  'IAX',
 18  'IAD',
 19  'GCSX',
 20  'GCSD',
 21  'FUNX',
 22  'FUND',
 23  'FPAX',
 24  'FPAD',
 25  'ASNX',
 26  'ASND',
 27  'AMWX',
 28  'AMWD'
 29* )
SQL> /

no rows selected

In an SR logged with Oracle, they said:

Hi,

Sometimes this happens with OATM.
But the cause is yet to be determioned.
If no objects are present i these tablespaces they can be dropped manually without issues.

Based on this, we dropped these empty tablespaces manually.

No comments: