Toad World® Forums

Table Rebuild

What does TOAD do when rebuild table command is done?

A DBA here did a rebuild table in error. We saw a new table with same name and “_X” appended. Original table empty of rows.

Open the rebuild table screen, select a table, and select the SQL tab. Toad will generate the SQL without running it so you can see exactly what it does.

From: briley [mailto:bounce-briley@toadworld.com]

Sent: Wednesday, January 14, 2015 4:26 PM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] Table Rebuild

Table Rebuild

Thread created by briley

What does TOAD do when rebuild table command is done?

A DBA here did a rebuild table in error. We saw a new table with same name and “_X” appended. Original table empty of rows.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

That’s the original table with the _X. It’s just been renamed. You can get back to your original state like this:

  1. Make sure that all of your indexes, triggers, constraints are on the _X table

  2. Drop the table of the original name.

  3. Rename the _X table back to the original name.

Yes. That worked out very well. Now I see and understand what the command will do.

Bruce

From: Brad Boddicker [mailto:bounce-ButtonPusher@toadworld.com]

Sent: Wednesday, January 14, 2015 4:29 PM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Table Rebuild

RE: Table Rebuild

Reply by Brad Boddicker

Open the rebuild table screen, select a table, and select the SQL tab. Toad will generate the SQL without running it so you can see exactly what it does.

From: briley [mailto:bounce-briley@toadworld.com]

Sent: Wednesday, January 14, 2015 4:26 PM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] Table Rebuild

Table Rebuild

Thread created by briley

What does TOAD do when rebuild table command is done?

A DBA here did a rebuild table in error. We saw a new table with same name and “_X” appended. Original table empty of rows.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

CONFIDENTIALITY NOTICE: The information in this e-mail message and any attachments may contain privileged, confidential or proprietary information, including confidential health information, protected by applicable Federal or state laws. Such information is
intended only for the recipient named above. If you are not the intended recipient, please notify the sender immediately, and take notice that any use, disclosure or distribution of such information is prohibited by law.

Toad version of rebuilding table allow DBA (owner) to regenerate table as well (fully automatic) as adding some columns or other structure or even data (semi automatic need to change some parts of generated script depending your need).

Oracle rebuild is intended just to rebuild some smaller structure parts (i.e. defragmentation or some other storage changes) without any possibility to change/add columns or existing data.

Please be aware that while Oracle’s rebuild may be done online on production Toad way always generate invalid objects (of depended code) or disable constraints for a while and in the end recompile invalid packages. So it has to be executed with more caution than Oracle’s rebuild.

And for the end please understand that Toad rebuild is like missing point from what other tools offer now… and in this way is very very nice tool but should be run with little more caution on PROD envs.