Home » RDBMS Server » Server Utilities » Direct load in append
Direct load in append [message #72921] Fri, 12 December 2003 15:44 Go to next message
Sanjay
Messages: 236
Registered: July 2000
Senior Member
Hi,
I was reading thru one of the OCP prep document. Here it is mentioned that in Parallel Direct Load of Oracle , oracle loads the data above high water mark. and the below High water mark will get wasted.

Should we be then using the TRUNCATE command to truncate the table before using DIRECT load ? Your inputs greatly apprecaites

Thanks
Sanjay
Re: Direct load in append [message #72923 is a reply to message #72921] Mon, 15 December 2003 02:27 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
any load or insert statement will insert data above the Highwater mark only.
so, 
1. truncate data before load or
2. after load export the table and import again with compress=y or
3. move the table to the same tablespace
   alter table table_name move tablespace same_tablespace_name_;

Previous Topic: inserting negetive number in a number column fails..
Next Topic: Exporting a row
Goto Forum:
  


Current Time: Wed Jun 26 12:40:16 CDT 2024