Re: DWH loading : Do you use 2 types of tablespaces ?

From: Darrell Landrum <darrell_at_landrum.com>
Date: Tue, 1 Jun 2004 06:59:52 -0500
Message-ID: <004401c447cf$f2e8c540$6501a8c0@darrell1>

DWH loading : Do you use 2 types of tablespaces ?Do your alter table move again, then try to resize your datafiles.

Original Message ----- From: NGUYEN Philippe (Cetelem) To: 'oracle-l_at_freelists.org' Sent: Tuesday, June 01, 2004 2:14 AM Subject: DWH loading : Do you use 2 types of tablespaces ?

Oracle 9R2,
Tablepsace LMT / extent uniform size

Hi gurus!
after loading my table with an ETL my my_big_table took 22Go. after a "alter table big_table move " --> move in the same tablespace, it decreased to 10 Go. So, now I want to retrieve the unused space from my tablespace again but reducing datafiles give me an ORA-03297 (files contains used data beyond requested RESIZE value).

I guess alter 'table my_big_table move tablespace an_other_tablespace' would solve the problem so my questions are :

For a DWH , do you use to use 2 type of tablespace , one for the loading operation and one for de definitive use.
Is there other solution avoid the use of two tablespaces ?

Thanks in advance !
Philippe

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_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

Received on Tue Jun 01 2004 - 06:57:04 CDT