Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 32027 invoked from network); 8 Aug 2006 13:31:43 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 8 Aug 2006 13:31:40 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 323AF3BE55D; Tue, 8 Aug 2006 14:31:18 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 15781-02; Tue, 8 Aug 2006 14:31:18 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9A4C13BE55B; Tue, 8 Aug 2006 14:31:17 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 08 Aug 2006 14:30:27 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 688093BD719 for ; Tue, 8 Aug 2006 14:30:27 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 15664-04 for ; Tue, 8 Aug 2006 14:30:27 -0400 (EDT) Received: from intlexchange.pqilintl.net (host.chadwyck.co.uk [195.22.151.242]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3B67D3BD82A for ; Tue, 8 Aug 2006 14:30:24 -0400 (EDT) Received: from AABO-EXCHANGE02.bos.il.pqe ([172.24.3.200]) by intlexchange.pqilintl.net with Microsoft SMTPSVC(6.0.3790.1830); Tue, 8 Aug 2006 19:30:34 +0100 x-mimeole: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C6BB18.BA3FCAE3" Subject: RE: export from Enterprise Edition to Standard Edition db - how to disable table compression? Date: Tue, 8 Aug 2006 14:31:16 -0400 Message-ID: In-Reply-To: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: export from Enterprise Edition to Standard Edition db - how to disable table compression? From: "Bobak, Mark" To: , Cc: "oracle-l" X-OriginalArrivalTime: 08 Aug 2006 18:30:34.0696 (UTC) FILETIME=[BCC03480:01C6BB18] X-archive-position: 37900 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: Mark.Bobak@il.proquest.com Precedence: normal Reply-to: Mark.Bobak@il.proquest.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at avenirtech.net ------_=_NextPart_001_01C6BB18.BA3FCAE3 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Actually, since compressed table feature is intended for data warehouses, I think it makes sense to not be in SE. =20 -Mark =20 --=20 Mark J. Bobak=20 Senior Oracle Architect=20 ProQuest Information & Learning=20 Ours is the age that is proud of machines that can think and suspicious of men who try to. --H. Mumford Jones, 1892-1980 =20 ________________________________ From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Dennis Williams Sent: Tuesday, August 08, 2006 2:14 PM To: alaxsxaq@gmail.com Cc: oracle-l Subject: Re: export from Enterprise Edition to Standard Edition db - how to disable table compression? Glenn, =20 This difference between EE and SE makes no sense to me, so you may want to investigate it further, like try to create a compressed table in your SE database.=20 I usually prefer to create the objects separately from loading data. Offers an opportunity to deal with any object creation problems before loading the data. It is much easier to fix an empty table. =20 Dennis Williams =20 ------_=_NextPart_001_01C6BB18.BA3FCAE3 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
Actually, since compressed table feature is intended for data = warehouses,=20 I think it makes sense to not be in SE.
 
-Mark
 

--
Mark J. Bobak
Senior Oracle Architect =
ProQuest Information & = Learning

Ours is the age that is proud of = machines=20 that can think and suspicious of men who try to.  --H. Mumford = Jones,=20 1892-1980

 

From: oracle-l-bounce@freelists.org=20 [mailto:oracle-l-bounce@freelists.org] On Behalf Of Dennis=20 Williams
Sent: Tuesday, August 08, 2006 2:14 PM
To:=20 alaxsxaq@gmail.com
Cc: oracle-l
Subject: Re: export = from=20 Enterprise Edition to Standard Edition db - how to disable table=20 compression?

Glenn,
 
This difference between EE and SE makes no sense to me, so you may = want to=20 investigate it further, like try to create a compressed table in your SE = database.
    I usually prefer to create the objects = separately from=20 loading data. Offers an opportunity to deal with any object creation = problems=20 before loading the data. It is much easier to fix an empty table.
 
Dennis Williams

 
------_=_NextPart_001_01C6BB18.BA3FCAE3-- -- http://www.freelists.org/webpage/oracle-l