re: PCTFREE and data warehousing

  • From: "Ben" <poelsb@xxxxxxxxxxxxxxx>
  • To: "Oracle-L@Freelists. Org" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 22 Jun 2004 08:54:16 -0400

Thanks Paul, Ron and Graeme for the replies.

Paul - yes it does use DIRECT mode SQL*LDR load, I will remove the DIRECT
for the next load and see if it grabs any new extents.

Ron - I am going to move the database to a new server in a few months so I
will be re-creating the table.

Graeme - Partitioning is definitely the long term solution, especially since
this is a year based fact table. I will be implementing this when I migrate
the database.

Ben

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: