From oracle-l-bounce@freelists.org Mon Jul 26 13:20:51 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6QIKai05586 for ; Mon, 26 Jul 2004 13:20:46 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i6QIKQ605409 for ; Mon, 26 Jul 2004 13:20:36 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 92F3872CE57; Mon, 26 Jul 2004 12:58:57 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 04063-17; Mon, 26 Jul 2004 12:58:57 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DA10D72C3A8; Mon, 26 Jul 2004 12:58:56 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 26 Jul 2004 12:57:30 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AE1CC72C0F7 for ; Mon, 26 Jul 2004 12:57:29 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 02748-36 for ; Mon, 26 Jul 2004 12:57:29 -0500 (EST) Received: from MXR-2.estpak.ee (ld3.estpak.ee [194.126.101.102]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 33CA272C02D for ; Mon, 26 Jul 2004 12:57:29 -0500 (EST) Received: from porgand (213-35-250-91-dsl.kvm.estpak.ee [213.35.250.91]) by MXR-2.estpak.ee (Postfix) with SMTP id B39FF6085A for ; Mon, 26 Jul 2004 21:24:12 +0300 (EEST) Message-ID: <383c01c4733d$bfb647d0$0a879fd9@porgand> From: =?ISO-8859-1?Q?Tanel_P=F5der?= To: References: <20040726181414.16344.qmail@web51306.mail.yahoo.com> Subject: Re: Partition Advice Date: Mon, 26 Jul 2004 21:24:11 +0300 MIME-Version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at neti.ee X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 6032 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: tanel.poder.003@mail.ee Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org You could use: alter table emp exchange partition old_partition with table employee; And then rebuild any indexes on this partition. That way the physical contents of old_partition in emp table table are replaced with contents of employee table (using a data dictionary update, no real data is moved around). If you are sure about validity of data in the employee table, you could add "without validation" clause to the exchange partition syntax, that way the exchange operation itself will be faster. There are some issues though, I recommend you to read Jonathan Lewis'es article on this: http://www.dbazine.com/jlewis17.shtml Tanel. ----- Original Message ----- From: "Sanjay Mishra" To: Sent: Monday, July 26, 2004 9:14 PM Subject: Partition Advice > > I have a prod database where we have one of the big > table been partioned on Weekly basis and each week > data is around 40G. Today I checked that our RMAN > backup is still showing Sucess at the end but been > failing from last one week on one of the datafile and > generated an IO error and then found that there are > several block is been corrupted and it is Sun > platform. I cannot copy the 30 G datafile using any OS > utilities from one filesystem to another as it fail > with same error. > > Now I cannot recover as I don't have good backup of > this file but as the user are not accessing this old > partition and so there are no report been made and > system is fine. I had create new table now and > populated all of the 2 million record in it and only > lost 10 records. Now can somebody suggest as how can I > put this data back to the parititon. I am going to > drop the old parition and it is of no issue [ I hope > so ] as I had made the file offline and online > yesterday with problem and even bounced the database. > So is there any way that I can drop the old partition > and put this new data into this place. Original table > is emp and new recovered table is Employee > > Thanks for all help ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------