From oracle-l-bounce@freelists.org Tue Jun 1 10:01:22 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i51F17Q24658 for ; Tue, 1 Jun 2004 10:01:17 -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 i51F0v624626 for ; Tue, 1 Jun 2004 10:01:07 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C67A972C4B2; Tue, 1 Jun 2004 09:47:47 -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 19341-63; Tue, 1 Jun 2004 09:47:47 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EB38172C3D3; Tue, 1 Jun 2004 09:47:46 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 01 Jun 2004 09:46:26 -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 ADA6D72C307 for ; Tue, 1 Jun 2004 09:46:22 -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 19415-19 for ; Tue, 1 Jun 2004 09:46:22 -0500 (EST) Received: from xenon.neuges.net (xenon.neuges.net [194.250.170.150]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CC36972C072 for ; Tue, 1 Jun 2004 09:46:21 -0500 (EST) Received: from somewhere.xenon by somewhere.xenon (8.9.3/8.9.3/1.1.3) with ESMTP id RAA11262 for ; Tue, 1 Jun 2004 17:06:39 +0200 (MET DST) Received: from somewhere.xenon by somewhere.xenon (8.9.3/8.9.3/1.1.3) with ESMTP id RAA11254 for ; Tue, 1 Jun 2004 17:06:39 +0200 (MET DST) Received: from somewhere.diderot2 by somewhere.diderot2 (8.9.3/8.9.3) with ESMTP id RAA24642 for ; Tue, 1 Jun 2004 17:04:01 +0200 (MEST) Received: by ngmailroute.pc.ctlmcof.fr with Internet Mail Service (5.5.2657.72) id ; Tue, 1 Jun 2004 17:04:33 +0200 Message-ID: From: "NGUYEN Philippe (Cetelem)" To: "'oracle-l@freelists.org'" Subject: RE: DWH loading : Do you use 2 types of tablespaces ? Date: Tue, 1 Jun 2004 17:04:23 +0200 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C447E8.988D77DF" X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 1701 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: philippe.nguyen@cetelem.fr Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org ------_=_NextPart_001_01C447E8.988D77DF Content-Type: text/plain; charset="iso-8859-1" Thanks for your reponses : 1. Dareell : I do 'alter move ' 2 or 3 times and it works===> COOL !! 2. Ryan : my table is set with pctused 99 and pctfree 1 but as my ETL (PX+Dastage) is using parallel loaders (x4) with Direct Path I suppose that each nodes used new extents for its loading. So we waste space. 3. Dennis : is it a bests practises doing so ? (I mean using 2 type of tbs ?) ------_=_NextPart_001_01C447E8.988D77DF Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: DWH loading : Do you use 2 types of tablespaces ?

Thanks for your reponses :

1. Dareell : I do 'alter move ' 2 or 3 times and it = works=3D=3D=3D> COOL !!
2. Ryan : my table is set with pctused 99 and = pctfree 1 but as my ETL (PX+Dastage) is using parallel loaders (x4) = with Direct Path I suppose that each nodes used new extents for its = loading. So we waste space.

3. Dennis : is it a bests practises doing so ? (I = mean using 2 type of tbs ?)
 

------_=_NextPart_001_01C447E8.988D77DF-- ---------------------------------------------------------------- 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 -----------------------------------------------------------------