issue about table reorg

[#1]

Hi SAP,

We reorg some tables using brspace.

After reorg, qlik can't extract data from database.

I want to know the mechanism of brspace. Does it create new table during reorg?

Best Regards.

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

Dear Customer,

During the reorganization, Oracle creates some temporary objects, such as Materialized-View Logs (MLOG$_<table>) or indexes that support ROWID constraints (I_SNAP$_<table>#$), in the SAP user's (SAPR3 or SAP<SID>) default tablespace (PSAPUSER1D oder PSAP<SID>USR).

For more information, please check below note:

646681 - Reorganization of tables with BRSPACE

Best regards