oracle Database reorganization issue fact tablespace

[Former Member]

Hi ALL,

we are currently in process of Re-oraganization of our SAP system(APO) database, we are currently running in oracle 10.2G with latest patch and Brtools 7.0 patch34,

we have taken into account all SAP Note 646681( re-organization with brspace),771191 ( for BI tablesapces) and table- class values during New tablespace creation

our Reorginization is allmost 99% succesfull for all tablespaces expect some indexes (5 partation indexes) still in old tablesapace and tables are in New tablespace, i am not able to understand why ony few indexes still left in old tablespace

partation index are :- 1 /BIC/FZSP_C050

2 /BIC/FZSP_C050000000015

Note :- we are also moving from old database layout to new database layout earlier we had new tablesapce PSAPFACD, and PSAPFACTI now all tables move to New tablespace PSAPAPOFACT, all tables moved to PSAPAPOFACD New and most of the indexes as well expect few as given above not gone to new tablespace....

please help

Thanks,

Dinesh

[Former Member · Accepted solution]

Hi,

i am able to find the problem, but why it is . still i question, during Reorg. we have created to tablespace PSAPAPOFACT with class PSAPFACTD and PSAPAPOFACTI,

and run the br command comamnd with surct tablespace PSAPFACTD and target tablespace PSAPAPOFACTI, it has succesfull moved all the table from PSAPFACD to PSAPAPOFACT and most of the indexes, we found that it has also successfully changed in dba_part_tables dafault tablespace attribute value

but for some reason, it is not chagned for indexes in dba_Part_indexes view for some indexes, can any tell what could be teh cause for that, for some indexes it is stil old tablespace check the bold one below

SQL> select INDEX_NAME, DEF_TABLESPACE_NAME from dba_part_indexes;

INDEX_NAME DEF_TABLESPACE_NAME

-

---

-

---

/BIC/FZSP_C02~020 PSAPAPOFACT

/BIC/FZSP_C02~040 PSAPAPOFACT

/BIC/FZSP_C02~050 PSAPAPOFACT

/BIC/FZSP_C02~010 PSAPAPOFACT

/BIC/FZSP_C02~030 PSAPAPOFACT

/BIC/FZSP_C02~060 PSAPAPOFACT

/BIC/FZSP_C02~070 PSAPAPOFACT

/BIC/FZSP_C02~080 PSAPAPOFACT

LOGMNR_I2TABPART$ SYSAUX

LOGMNR_I2INDPART$ SYSAUX

LOGMNR_I2TABCOMPART$ SYSAUX

INDEX_NAME DEF_TABLESPACE_NAME

-

---

-

---

LOGMNR_I2TABSUBPART$ SYSAUX

LOGMNR_I2IND$ SYSAUX

LOGMNR_I2TAB$ SYSAUX

LOGMNRC_I2GTLO SYSAUX

/BIC/FZADAU_C02~01 PSAPFACTI

/BIC/FZADAU_C02~02 PSAPFACTI

/BIC/FZADAU_C02~03 PSAPFACTI

/BIC/FZADAU_C02~04 PSAPFACTI

/BIC/FZADAU_C02~05 PSAPFACTI

/BIC/FZADAU_C02~06 PSAPFACTI

/BIC/FZADAU_C02~07 PSAPFACTI

INDEX_NAME DEF_TABLESPACE_NAME

-

---

-

---

/BIC/FZADAU_C02~08 PSAPFACTI

LOGMNRC_GTLO_PK SYSAUX

LOGMNRC_GSII_PK SYSAUX

/BIC/FZDP_C01~010 PSAPFACTI

/BIC/FZDP_C01~020 PSAPFACTI

/BIC/FZDP_C01~030 PSAPFACTI

/BIC/FZDP_C01~040 PSAPFACTI

/BIC/FZDP_C01~050 PSAPFACTI

/BIC/FZDP_C01~060 PSAPFACTI

/BIC/FZDP_C01~070 PSAPFACTI

/BIC/FZDP_C01~080 PSAPFACTI

INDEX_NAME DEF_TABLESPACE_NAME

-

---

-

---

/BIC/FZPROD_ALC~01 PSAPAPOFACT

/BIC/FZPROD_ALC~02 PSAPAPOFACT

/BIC/FZPROD_ALC~03 PSAPAPOFACT

/BIC/FZPROD_ALC~04 PSAPAPOFACT

/BIC/FZSP_C03~010 PSAPAPOFACT

/BIC/FZSP_C03~020 PSAPAPOFACT

/BIC/FZSP_C03~030 PSAPAPOFACT

/BIC/FZSP_C03~040 PSAPAPOFACT

/BIC/FZSP_C03~050 PSAPAPOFACT

/BIC/FZSP_C03~060 PSAPAPOFACT

/BIC/FZSP_C03~070 PSAPAPOFACT

[former_member204746 · Accepted solution]

again, BW keeps on droping and creating tables and indexes. so, ehwn it does that, it uses the data dictionnary to accomplish its task.

because you have not changed data dictionnary class, all new objects will be created in the tablespace defined in data dictionary. This is completely normal.

Are you planning on keeping these new tablespace? if you plan on renaming them, check the following:

for all new objects to be created in new tablespace:

update sapr3.taora set TABSPACE='PSAPFACT2D' where TABART='DFACT';

update sapr3.iaora set TABSPACE='PSAPFACT2I' where TABART='DFACT';

commit;

optional:

create a new type (TABART) in TAORA and IAORA and adapt table DD09L, field TABART for moved tables.

Also consider adapting table RSDCUBE fields CUBEDATCLS, DIMEDATCLS, AGGRDATCLS and ADMIDATCLS.

Also check ODS objects table RSDODSO, fields ODSADATCLS and ODSMDATCLS

also check PSA table RSTS, field PSADATCLS

change partition info for moved table:

alter table sapr3."/BIC/Fzzzazzz" modify default attributes tablespace PSAPFACT2D;

alter table sapr3."/BIC/Eyyyyyyy" modify default attributes tablespace PSAPFACT2D;

select table_name from dba_tables where tablespace_name='PSAPFACTD';

check if tablespace is empty:

select * from dba_segments where tablespace_name= like 'PSAPFACT%';

STOP SAP

drop tablespace PSAPFACTD

drop tablesapce PSAPFACTI

brspace -c force -f tsalter -a rename -t PSAPFACT2D -n PSAPFACTD

brspace -c force -f tsalter -a rename -t PSAPFACT2I -n PSAPFACTI

delete from sapr3.iaora where tabspace='PSAPFACT2D';

delete from sapr3.iaora where tabspace='PSAPFACT2I';

delete from sapr3.taora where tabspace='PSAPFACT2I';

delete from sapr3.taora where tabspace='PSAPFACT2D';

[Former Member · Accepted solution]

Hi Eric,

thanks for the reply, i changed the attribute of the indexes using commands

alter table sapr3."/BIC/Fzzzazzz" modify default attributes tablespace PSAPFACT2D

and i observed that in my system, indexes which left in old tablesapce, drop and recreate every morning by some jobs..(as partation indexes)

after chaging the attribute,indexes moved in new tablespace inself after recreation in next day,

Thanks for the help provided

Dinesh

[former_member204746 · Accepted solution]

thanks, but take note that you may need to adapt others tables in the data dictionary for future cubes that your BW guy might create.

[Former Member · Accepted solution]

Hi Eric,

I checked TAORA, IAORA , dba_part_tables and dba_part_indexes all are up to date with new tablespace name,old tablesapce PSAPFACD/I is replaced with PSAPAPOFACT,

do i still get problem in future

SQL> select * from sapr3.tsora;

TABSPACE INDSPACE

-

---

-

---

PSAPAPO700 PSAPAPO700

PSAPAPOODS PSAPAPOODS

PSAPYBMC PSAPYBMC

PSAPAPODIM PSAPAPODIM

PSAPAPOUSR PSAPAPOUSR

PSAPAPOFACT PSAPAPOFACT

PSAPAPO PSAPAPO

PSAPSTABD PSAPSTABI

PSAPBTABD PSAPBTABI

PSAPPOOLD PSAPPOOLI

PSAPCLUD PSAPCLUI

TABSPACE INDSPACE

-

---

-

---

PSAPDIMD PSAPDIMI

PSAPFACTD PSAPFACTI

PSAPODSD PSAPODSI

PSAPDDICD PSAPDDICI

PSAPDOCUD PSAPDOCUI

PSAPEL700D PSAPEL700I

PSAPLOADD PSAPLOADI

PSAPPROTD PSAPPROTI

PSAPES700D PSAPES700I

PSAPSOURCED PSAPSOURCEI

PSAPUSER1D PSAPUSER1I

TABSPACE INDSPACE

-

---

-

---

PSAPYBMCD PSAPYBMCI

23 rows selected.

SQL> select * from sapr3.taora;

TABAR TABSPACE PCTI OFR OF OP OP

-

---

-

---

-

---

--- -- -- --

APPL0 PSAPAPODIM 0000 1 1 10 40

APPL1 PSAPAPOFACT 0000 1 1 10 40

APPL2 PSAPAPO 0000 1 1 10 40

CLUST PSAPAPO 0000 1 1 10 40

DDIM PSAPAPODIM 0000 001 01 00 60

DFACT PSAPAPOFACT 0000 004 01 10 60

DODS PSAPAPOODS 0000 004 01 00 60

POOL PSAPAPO 0000 1 1 10 40

SDIC PSAPAPO 0000 1 1 10 40

SDOCU PSAPAPO 0000 1 1 10 40

SLDEF PSAPAPO700 0000 1 1 10 40

TABAR TABSPACE PCTI OFR OF OP OP

-

---

-

---

-

---

--- -- -- --

SLEXC PSAPAPO700 0000 1 1 10 40

SLOAD PSAPAPO 0000 1 1 10 40

SPROT PSAPAPO 0000 1 1 10 40

SSDEF PSAPAPO700 0000 1 1 10 40

SSEXC PSAPAPO700 0000 1 1 10 40

SSRC PSAPAPO 0000 1 1 10 40

TEMP PSAPAPO 0000 1 1 10 40

USER PSAPAPOUSR 0000 1 1 10 40

USER1 PSAPAPOUSR 0000 1 1 10 40

USER2 PSAPYBMC 0 1 1 10 40

YBMC PSAPYBMC 0000 001 01 10 40

22 rows selected.

SQL> select * from sapr3.iaora;

TABAR TABSPACE PCTI OFR OP

-

---

-

---

-

---

--- --

USER2 PSAPYBMC 0 1 10

YBMC PSAPYBMC 0000 001 10

APPL0 PSAPAPODIM 0000 1 10

APPL1 PSAPAPOFACT 0000 1 10

APPL2 PSAPAPO 0000 1 10

CLUST PSAPAPO 0000 1 10

DDIM PSAPAPODIM 0000 001 10

DFACT PSAPAPOFACT 0000 004 10

DODS PSAPAPOODS 0000 004 10

POOL PSAPAPO 0000 1 10

SDIC PSAPAPO 0000 1 10

TABAR TABSPACE PCTI OFR OP

-

---

-

---

-

---

--- --

SDOCU PSAPAPO 0000 1 10

SLDEF PSAPAPO700 0000 1 10

SLEXC PSAPAPO700 0000 1 10

SLOAD PSAPAPO 0000 1 10

SPROT PSAPAPO 0000 1 10

SSDEF PSAPAPO700 0000 1 10

SSEXC PSAPAPO700 0000 1 10

SSRC PSAPAPO 0000 1 10

TEMP PSAPAPO 0000 1 10

USER PSAPAPOUSR 0000 1 10

USER1 PSAPAPOUSR 0000 1 10

22 rows selected.

SQL> select TABLE_NAME, DEF_TABLESPACE_NAME from dba_part_tables;

TABLE_NAME DEF_TABLESPACE_NAME

-

---

-

---

/BIC/FZSP_C02 PSAPAPOFACT

/BIC/B0000213000 PSAPAPOODS

/BIC/B0000202002 PSAPAPOODS

/BIC/B0000240000 PSAPAPOODS

/BIC/B0000243000 PSAPAPOODS

LOGMNR_TAB$ SYSAUX

LOGMNR_COL$ SYSAUX

LOGMNR_ATTRCOL$ SYSAUX

LOGMNR_TS$ SYSAUX

LOGMNR_IND$ SYSAUX

LOGMNR_TABPART$ SYSAUX

TABLE_NAME DEF_TABLESPACE_NAME

-

---

-

---

LOGMNR_TABSUBPART$ SYSAUX

LOGMNR_TABCOMPART$ SYSAUX

LOGMNR_TYPE$ SYSAUX

LOGMNR_COLTYPE$ SYSAUX

LOGMNR_ATTRIBUTE$ SYSAUX

LOGMNR_LOB$ SYSAUX

LOGMNR_CDEF$ SYSAUX

LOGMNR_CCOL$ SYSAUX

LOGMNR_ICOL$ SYSAUX

LOGMNR_LOBFRAG$ SYSAUX

LOGMNR_INDPART$ SYSAUX

TABLE_NAME DEF_TABLESPACE_NAME

-

---

-

---

LOGMNR_INDSUBPART$ SYSAUX

LOGMNR_INDCOMPART$ SYSAUX

LOGSTDBY$APPLY_PROGRESS SYSAUX

LOGMNR_DICTSTATE$ SYSAUX

LOGMNR_DICTIONARY$ SYSAUX

LOGMNR_OBJ$ SYSAUX

LOGMNR_USER$ SYSAUX

LOGMNRC_GTLO SYSAUX

LOGMNRC_GTCS SYSAUX

LOGMNRC_GSII SYSAUX

/BIC/FZSP_C03 PSAPAPOFACT

TABLE_NAME DEF_TABLESPACE_NAME

-

---

-

---

/BIC/FZZCAR PSAPAPOFACT

/BIC/B0000299000 PSAPAPOODS

/BIC/B0000259000 PSAPAPOODS

/BIC/B0000260000 PSAPAPOODS

/BIC/B0000261000 PSAPAPOODS

/BIC/B0000256000 PSAPAPOODS

/BIC/B0000263000 PSAPAPOODS

/BIC/B0000264000 PSAPAPOODS

/BIC/B0000253000 PSAPAPOODS

/BIC/B0000266000 PSAPAPOODS

/BIC/B0000265000 PSAPAPOODS

TABLE_NAME DEF_TABLESPACE_NAME

-

---

-

---

/BIC/B0000267000 PSAPAPOODS

/BIC/B0000268000 PSAPAPOODS

/BIC/B0000269000 PSAPAPOODS

/BIC/B0000270000 PSAPAPOODS

/BIC/B0000271000 PSAPAPOODS

/BIC/B0000112000 PSAPAPOODS

/BIC/B0000114000 PSAPAPOODS

/BIC/B0000113000 PSAPAPOODS

/BIC/B0000120000 PSAPAPOODS

/BIC/B0000115000 PSAPAPOODS

/BIC/B0000116000 PSAPAPOODS

TABLE_NAME DEF_TABLESPACE_NAME

-

---

-

---

/BIC/B0000118000 PSAPAPOODS

/BIC/B0000121000 PSAPAPOODS

/BIC/B0000122000 PSAPAPOODS

/BIC/B0000123000 PSAPAPOODS

/BIC/B0000124000 PSAPAPOODS

/BIC/B0000125000 PSAPAPOODS

/BIC/B0000144000 PSAPAPOODS

/BIC/B0000126000 PSAPAPOODS

/BIC/B0000130000 PSAPAPOODS

/BIC/B0000129000 PSAPAPOODS

/BIC/B0000145000 PSAPAPOODS

TABLE_NAME DEF_TABLESPACE_NAME

-

---

-

---

/BIC/B0000131000 PSAPAPOODS

/BIC/B0000151000 PSAPAPOODS

/BIC/B0000152000 PSAPAPOODS

/BIC/B0000159000 PSAPAPOODS

/BIC/B0000161001 PSAPAPOODS

/BIC/B0000162000 PSAPAPOODS

/BIC/B0000175000 PSAPAPOODS

/BIC/B0000174000 PSAPAPOODS

/BIC/B0000176000 PSAPAPOODS

/BIC/B0000177000 PSAPAPOODS

/BIC/B0000178000 PSAPAPOODS

TABLE_NAME DEF_TABLESPACE_NAME

-

---

-

---

/BIC/B0000179000 PSAPAPOODS

/BIC/B0000180000 PSAPAPOODS

/BIC/B0000184000 PSAPAPOODS

/BIC/B0000181000 PSAPAPOODS

/BIC/B0000182000 PSAPAPOODS

/BIC/B0000183000 PSAPAPOODS

/BIC/B0000166000 PSAPAPOODS

/BIC/B0000185000 PSAPAPOODS

/BIC/B0000204000 PSAPAPOODS

/BIC/B0000203000 PSAPAPOODS

/BIC/B0000206000 PSAPAPOODS

TABLE_NAME DEF_TABLESPACE_NAME

-

---

-

---

/BIC/B0000214000 PSAPAPOODS

/BIC/B0000198001 PSAPAPOODS

/BIC/B0000216000 PSAPAPOODS

/BIC/B0000215000 PSAPAPOODS

/BIC/B0000222000 PSAPAPOODS

/BIC/B0000224000 PSAPAPOODS

/BIC/B0000223000 PSAPAPOODS

/BIC/B0000226000 PSAPAPOODS

/BIC/B0000227000 PSAPAPOODS

/BIC/B0000229000 PSAPAPOODS

/BIC/B0000225000 PSAPAPOODS

TABLE_NAME DEF_TABLESPACE_NAME

-

---

-

---

/BIC/B0000232000 PSAPAPOODS

/BIC/B0000238000 PSAPAPOODS

/BIC/B0000233000 PSAPAPOODS

/BIC/B0000235000 PSAPAPOODS

/BIC/B0000234000 PSAPAPOODS

/BIC/B0000236000 PSAPAPOODS

/BIC/B0000210000 PSAPAPOODS

/BIC/B0000237000 PSAPAPOODS

STREAMS$_APPLY_SPILL_MSGS_PART SYSAUX

/BIC/B0000244000 PSAPAPOODS

/BIC/B0000239000 PSAPAPOODS

TABLE_NAME DEF_TABLESPACE_NAME

-

---

-

---

/BIC/B0000241000 PSAPAPOODS

/BIC/B0000242000 PSAPAPOODS

/BIC/B0000250000 PSAPAPOODS

/BIC/B0000245000 PSAPAPOODS

/BIC/B0000246000 PSAPAPOODS

/BIC/B0000247000 PSAPAPOODS

/BIC/B0000248000 PSAPAPOODS

/BIC/B0000249000 PSAPAPOODS

/BIC/B0000254000 PSAPAPOODS

/BIC/B0000252000 PSAPAPOODS

/BIC/B0000251000 PSAPAPOODS

TABLE_NAME DEF_TABLESPACE_NAME

-

---

-

---

/BIC/B0000255000 PSAPAPOODS

/BIC/B0000258000 PSAPAPOODS

/BIC/FZDP_C01 PSAPAPOFACT

/BIC/B0000272000 PSAPAPOODS

/BIC/B0000273000 PSAPAPOODS

/BIC/B0000275000 PSAPAPOODS

/BIC/B0000278000 PSAPAPOODS

/BIC/B0000274000 PSAPAPOODS

/BIC/B0000276000 PSAPAPOODS

/BIC/B0000277000 PSAPAPOODS

/BIC/B0000280000 PSAPAPOODS

TABLE_NAME DEF_TABLESPACE_NAME

-

---

-

---

/BIC/B0000279000 PSAPAPOODS

/BIC/B0000282000 PSAPAPOODS

/BIC/B0000281000 PSAPAPOODS

/BIC/B0000285000 PSAPAPOODS

/BIC/B0000187000 PSAPAPOODS

/BIC/B0000287000 PSAPAPOODS

/BIC/B0000289000 PSAPAPOODS

/BIC/B0000297000 PSAPAPOODS

/BIC/B0000286000 PSAPAPOODS

/BIC/B0000262000 PSAPAPOODS

/BIC/B0000298000 PSAPAPOODS

TABLE_NAME DEF_TABLESPACE_NAME

-

---

-

---

/BIC/B0000300000 PSAPAPOODS

/BIC/B0000301000 PSAPAPOODS

/BIC/B0000302000 PSAPAPOODS

/BIC/B0000304000 PSAPAPOODS

/BIC/B0000308000 PSAPAPOODS

/BIC/B0000309000 PSAPAPOODS

/BIC/B0000310000 PSAPAPOODS

/BIC/B0000311000 PSAPAPOODS

/BIC/B0000312000 PSAPAPOODS

/BIC/B0000313000 PSAPAPOODS

/BIC/B0000314000 PSAPAPOODS

TABLE_NAME DEF_TABLESPACE_NAME

-

---

-

---

/BIC/B0000315000 PSAPAPOODS

/BIC/B0000316001 PSAPAPOODS

/BIC/B0000317000 PSAPAPOODS

/BIC/B0000318000 PSAPAPOODS

/BIC/B0000320000 PSAPAPOODS

/BIC/B0000305000 PSAPAPOODS

/BIC/B0000321000 PSAPAPOODS

/BIC/B0000322000 PSAPAPOODS

/BIC/B0000323000 PSAPAPOODS

/BIC/B0000324000 PSAPAPOODS

/BIC/B0000325000 PSAPAPOODS

TABLE_NAME DEF_TABLESPACE_NAME

-

---

-

---

/BIC/B0000327000 PSAPAPOODS

/BIC/B0000328000 PSAPAPOODS

/BIC/B0000329000 PSAPAPOODS

/BIC/B0000330000 PSAPAPOODS

/BIC/B0000332000 PSAPAPOODS

/BIC/B0000333000 PSAPAPOODS

/BIC/B0000334000 PSAPAPOODS

/BIC/B0000335000 PSAPAPOODS

/BIC/B0000336000 PSAPAPOODS

/BIC/B0000337000 PSAPAPOODS

/BIC/B0000338000 PSAPAPOODS

TABLE_NAME DEF_TABLESPACE_NAME

-

---

-

---

/BIC/B0000339000 PSAPAPOODS

/BIC/B0000340000 PSAPAPOODS

/BIC/B0000341000 PSAPAPOODS

/BIC/B0000342000 PSAPAPOODS

/BIC/B0000343000 PSAPAPOODS

/BIC/B0000303000 PSAPAPOODS

/BIC/B0000344000 PSAPAPOODS

/BIC/B0000345000 PSAPAPOODS

/BIC/B0000346000 PSAPAPOODS

/BIC/B0000347000 PSAPAPOODS

/BIC/B0000348000 PSAPAPOODS

TABLE_NAME DEF_TABLESPACE_NAME

-

---

-

---

/BIC/B0000319000 PSAPAPOODS

/BIC/B0000230000 PSAPAPOODS

WRH$_FILESTATXS SYSTEM

WRH$_SQLSTAT SYSTEM

WRH$_SYSTEM_EVENT SYSTEM

WRH$_WAITSTAT SYSTEM

WRH$_LATCH SYSTEM

WRH$_LATCH_CHILDREN SYSTEM

WRH$_LATCH_PARENT SYSTEM

WRH$_LATCH_MISSES_SUMMARY SYSTEM

WRH$_DB_CACHE_ADVICE SYSTEM

TABLE_NAME DEF_TABLESPACE_NAME

-

---

-

---

WRH$_ROWCACHE_SUMMARY SYSTEM

WRH$_SGASTAT SYSTEM

WRH$_SYSSTAT SYSTEM

WRH$_SYS_TIME_MODEL SYSTEM

WRH$_OSSTAT SYSTEM

WRH$_PARAMETER SYSTEM

WRH$_SEG_STAT SYSTEM

WRH$_DLM_MISC SYSTEM

WRH$_INST_CACHE_TRANSFER SYSTEM

WRH$_ACTIVE_SESSION_HISTORY SYSTEM

WRH$_TABLESPACE_STAT SYSTEM

TABLE_NAME DEF_TABLESPACE_NAME

-

---

-

---

WRH$_SERVICE_STAT SYSTEM

WRH$_SERVICE_WAIT_CLASS SYSTEM

/BIC/B0000331000 PSAPAPOODS

/BI0/9AFAPOCRM PSAPAPOFACT

/BI0/9AFSNPSA PSAPAPOFACT

/BI0/9AFSNPBAS PSAPAPOFACT

/BI0/9AFDPBAS PSAPAPOFACT

/BI0/9AFTSW_EXG PSAPAPOFACT

/BI0/9AFTSW_SO PSAPAPOFACT

/BI0/9AFTSW_SCQ PSAPAPOFACT

/BI0/F0RSTT_C01 PSAPAPOFACT

TABLE_NAME DEF_TABLESPACE_NAME

-

---

-

---

/BI0/F0RSTT_C02 PSAPAPOFACT

/BI0/F0RSTT_C04 PSAPAPOFACT

/BI0/F0RSTT_C03 PSAPAPOFACT

/BI0/F0RSTT_C05 PSAPAPOFACT

/BIC/F100003 PSAPAPOFACT

/BIC/F100004 PSAPAPOFACT

/BIC/FFVP_C01 PSAPAPOFACT

/BIC/FFSNP_C01 PSAPAPOFACT

/BIC/FZADCHK PSAPAPOFACT

/BIC/FZADAUGS PSAPAPOFACT

/BIC/FZDP_C02 PSAPAPOFACT

TABLE_NAME DEF_TABLESPACE_NAME

-

---

-

---

/BIC/FZDP_C03 PSAPAPOFACT

/BIC/FZDP_C04 PSAPAPOFACT

/BIC/FZDP_C14 PSAPAPOFACT

/BIC/FZDP_C10 PSAPAPOFACT

/BIC/FZDP_C51 PSAPAPOFACT

/BIC/FZDP_C25 PSAPAPOFACT

/BIC/FZADAU_C02 PSAPAPOFACT

/BIC/FZDP_C52 PSAPAPOFACT

/BIC/FZDP_C53 PSAPAPOFACT

/BIC/FZDP_C54 PSAPAPOFACT

/BIC/FZDP_C55 PSAPAPOFACT

TABLE_NAME DEF_TABLESPACE_NAME

-

---

-

---

/BIC/FZIR3 PSAPAPOFACT

/BIC/FZIR3D1 PSAPAPOFACT

/BIC/FZOPCO_C01 PSAPAPOFACT

/BIC/FZPOSDP PSAPAPOFACT

/BIC/FZPOSOPCO PSAPAPOFACT

/BIC/FZPOSREPL PSAPAPOFACT

/BIC/FZPRODALL PSAPAPOFACT

/BIC/FZREPL_C02 PSAPAPOFACT

/BIC/FZREPL_C03 PSAPAPOFACT

/BIC/FZREPL_C04 PSAPAPOFACT

/BIC/FZSAM1 PSAPAPOFACT

TABLE_NAME DEF_TABLESPACE_NAME

-

---

-

---

/BIC/FZSAM3 PSAPAPOFACT

/BIC/FZSECPROC PSAPAPOFACT

/BIC/FZPROD_ALC PSAPAPOFACT

/BIC/FZSP_C01 PSAPAPOFACT

/BIC/FZSP_C04 PSAPAPOFACT

Dinesh

[former_member204746 · Accepted solution]

Ok, all looks fine. you should be OK.

[former_member204746]

when reorging a BW system (or APO which is based on BW), new partitions can be created almost on-the-fly. in your case, this is what happened, and these partitions gets created in the original tablespace.

i have found the following topic which explains some table changes that must be done when reorging on BW systems:

http://www.sapfans.com/forums/viewtopic.php?f=12&t=255674&p=775259&hilit=psapfactd#p775259

so now, you will need to move these partitions back on the good tablespace, this is a pain and the only way I have found if to reorg the table and its indexes back to the destination tablespace.

when completed, shutdown your APO system, delete the old taglesapces, and rename your new tablespaces on the old tablespace name.

[Former Member]

HI Eric,

PSAPFACTD tablesapces confusing me lot, i reorg and found that indexes are still left in PSAPFACTI tablespace, but when i checked in next day.. indexes was clear itself.. this is creating more problem for me.. is it /BIC/F.... tables. keep changing?

how ia m going to take care of it.... i have done my Reorg. for QA system. now planning for production system ..only problem is this FACD inedex.. which i faced during QA reorg. rest went fine... do you have any idea?

Dinesh

[former_member204746]

BW keeps on creating new tables/indexes.. aand also partitions.

when it does, it reads the ABAP dictionary and check data class. this data class then uses a tablesapce definded in the dictionnary.

this is completely normal and expected.

so, you need to change ABAP dictionanry to point to your new tablespace.

as for partitions, you need to go at Oracle level and change the default tablespace for partitions. this is a pain...

so now, if you can handle the downtime, do this:

1. rename the PSAPFACTD to PSAPFACT2D

2. rename the PSAPFACTI to PSAPFACT2I

3. rename the PSAPAPOFACT to PSAPFACTD

one more question... have you created an index tablespace?