10g can do reorg with no downtime?

[Former Member]

I remember that I read somewhere about this but cannot verify it.

Please help confirm. Thanks!

[fidel_vales · Accepted solution]

Hello,

to provide similar information as Stefan, but from SAP point of view

[646681 Reorganizing tables with BRSPACE|http://service.sap.com/sap/support/notes/646681]

[835552 Oracle Database 10g: LONG-LOB migration|http://service.sap.com/sap/support/notes/835552]

and probably many others, but I think those two are the "key" ones.

[Former Member · Accepted solution]

Our question is that after a massive data archiving/deleting whether 10g will

do the reorg by itself without

1) manual scheduling

2) downtime?

Please detail more. Thanks!

[fidel_vales · Accepted solution]

hi,

>Our question is that after a massive data archiving/deleting whether 10g will

>do the reorg by itself without

>1) manual scheduling

NO, the reorganizations are "user" driven

> 2) downtime?

YES, if you choose to do an ONLINE reorganization

> Please detail more. Thanks!

Please, read the notes I pointed to, and the links Stefan wrote and afterwards you can ask about what parts you do NOT understand, not the other way around

[former_member204746 · Accepted solution]

a complete tablespace reorg will need some downtime for these steps:

reorg'ing tables which contains RAW or LONG RAW field types.

switching/renaming tablespace.

[stefan_koehler]

Hello,

you can do an online reorg with Oracle 10g... the online reorg does include some restrictions and some features..

For example take a look at sapnote #835552 or the oracle whitepaper:

http://www.oracle.com/technology/deploy/availability/htdocs/online.htm

The BR*Tools are also using the PL/SQL procedure DBMS_REDEFINITION.CAN_REDEF_TABLE for checking if the object can be reorganized.

http://download-uk.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_redefi.htm#i998726

For the restrictions take a look at here:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/tables.htm#i1106919

Regards

Stefan