From oracle-l-bounce@freelists.org Thu Jan 20 01:36:55 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j0K7asxh027265 for ; Thu, 20 Jan 2005 01:36:55 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j0K7asxu027261 for ; Thu, 20 Jan 2005 01:36:54 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 677DD72C892; Thu, 20 Jan 2005 01:36:14 -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 23607-62; Thu, 20 Jan 2005 01:36:14 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 91EFE72C012; Thu, 20 Jan 2005 01:34:21 -0500 (EST) Date: Thu, 20 Jan 2005 14:23:56 +0800 From: "biti_rainy" To: "oracle-l" Subject: (NEW) very interesting thing about migrate db from different OS(oracle 9.2.0.4,not 10G) Mime-Version: 1.0 Content-type: text/plain; charset=gb2312 Content-Transfer-Encoding: 8bit Message-Id: <20050120063047.027F472C2F9@turing.freelists.org> X-archive-position: 14972 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: biti_rainy@itpub.net Precedence: normal Reply-To: biti_rainy@itpub.net X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org X-Spam-Status: No, hits=0.0 required=5.0 tests=none autolearn=ham version=2.60 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com hi,all we find a very interesting thing: we copy the WINDOWS2000 datafile to linux (they have the same byte order) and , dd a linux datafile header to cover the windows datafile header(the header block is not include in dba_data_files),the block is not seem in database ,it is for OS. ls -l can see ,the datafile size is bigger than dba_data_files for one oracle block. when we change the OS file header,we can create controlfile and open the database ,and we can query /create table ... etc. the db version is oracle9204,not 10g. and someone told me that he can copy the datafile from windows and solaris for x86 pc to linux , and not change the header with oracle8i. is there someone can discuss it? Best regards msn: biti_rainy@hotmail.com a dba from alibaba(china) -- http://www.freelists.org/webpage/oracle-l