RE:

Kevin,  

Yes, you can do this with some precautions. The reorg is accomplished by moving the table. You can specify the same tablespace or another tablespace. You can even alter the storage parameters. One gotcha is having the spare space in your tablespaces to move the table. If you move the table to the same tablespace, you need free space in the tablespace equivalent to the table size plus some wiggle room (that's a technical term). Another thing to watch for is indexes that may be invalidated as a result of the move.  

Basic Syntax: Alter table {foo} move tablespace {bar} [ storage (initial xxM next xxM ...) ]  

Hope this helps,
Glen  

-----Original Message-----
From: Naik, Kevin K [ mailto:KNaik_at_mail.sbic.co.za <mailto:KNaik_at_mail.sbic.co.za> ]
Sent: Thursday, November 16, 2000 7:45 AM To: Multiple recipients of list ORACLE-L Subject:

Hello out there,

Oracle 8i claims to have the ability to do online re-orgs, has anybody actually done this without using
snapshots ?

Kevin N

        Disclaimer and confidentiality note

        Everything in this e-mail and any attachments relating to the official business of Standard Bank Investment Corporation (Stanbic) is proprietary to the company. It is confidential, legally privileged and protected by law. Stanbic does not own and endorse any other content. Views and opinions are those of the sender unless clearly stated as being that of Stanbic.

        The person addressed in the e-mail is the sole authorised recipient. Please notify the sender immediately if it has unintentionally reached you and do not read, disclose or use the content in any way.         

        Stanbic can not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference.