| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Rebuilding/Moving master table, snapshot log and snapshot
Good evening again, Mladen,
Thanks for this. Yes, I knew about the rebuilding of unusable indexes but just forgot to write it down.
We've logged a TAR with Oracle support and they were non-commital:
"It would be advisable that you first try the reorganization in your test database and then do it on Prod. This is because no such methods have been specified by Oracle for this purpose."
We've tested and wanted confirmation. Oh well, we're going ahead with it anyway.
Thanks again,
Leng.
Good evening dear sir from down under (It's 22:07, here in Connecticut).
Yes, it is safe to do. The only case when you do have to be careful is when
the table you want to take for a ride into another tablespace is an index
organized table and is being used. Then, you have to specify "online" option.
I was moving aound indexes, tables and partitions, without any problems. I
even moved a SYS table (AUD$) into another tablespace. No problem whatsoever.
On 2003.10.06 22:34, "Kaing, Leng" wrote:
> Good morning, everyone,
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kaing, Leng INET: Leng.Kaing_at_team.telstra.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue Oct 07 2003 - 20:39:25 CDT
 |
 |