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:
Post a Comment