Solution : https://service.sap.com/sap/support/notes/154193 (SAP Service marketplace login required)
Key words : 
single-row subquery returns, os> sapdba -analyze <table_name>, successfully allocating table <table>, single table reorg, cost based optimizer, sapdba automatically generates, sapdba delete function, sap abap dictionary, tablespace assignment field, earlier sapdba versions
Related Notes : 
       
| 771191 | Copying BW objects to new tablespaces | 
| 666061 | FAQ: Database objects, segments and extents | 
| 592393 | FAQ: Oracle | 
| 216303 | Corrections in SAPDBA version 4.6C | 
| 144326 | Corrections in the SAPDBA Version 4.6B | 
| 144323 | Corrections in SAPDBA Version 4.5B | 
| 125588 | Corrections in SAPDBA version 4.0B | 
| 125587 | Corrections in SAPDBA Version 3.1I |