Logging and nologging bulk insert

Posted on 16th Feb 2014 07:03 pm by admin

Hi,

oracle version: 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

I am trying to use Append during bulk insert?

example:

insert/*+ APPEND */ into t select * from dba_objects

Question:
-- Does this really works? i have read few articles but still clear.
-- If this works, what are things we need to take care? like table should be in nologging or index should be in no logging mode? or only Append hint si only required.
please explain in detail. how can this help with an example.

Your Answer:

Login to answer

Other forums

CE 7.1 and External GIS integration
Hi All,

We want to develop an application on CE 7.1 which uses GIS features from an exter

How to sum these output values
Hi

I need sum the month totals
SELECT region_name, area_name ,SUM (CASE WHEN S

Help! refer to a friend script with captcha code
Hi guys, I am posting on here in desperate need for some help with an ongoing search I have been doi

Using two $_POST Function / Switch () statements, second does not work.
Hi all. I’m new to php and am having a problem getting $_POST Function / switch () to work. I

Streaming local file from PHP while it’s been written to by a CURL process
I am creating a simple Proxy server for my website. Why I am not using mod_proxy and mod_cache is a

switch form actions? not working
i want on submit to go to different pages according to the CatID

Code: <?php $CatID=$_

mysql_affected_rows() usage
Possibly a MySQL issue, but the function that is not behaving in the anticipated way is a PHP functi

how to get different value in second view of webdynpro?
hello guys,

In ABAP webdynpro I am trying to create one application having two views.

Count of reciepients in php mailer
How can i sent a mail to large no of reciepients say 10,00,00 Using PHP MAILER

convert static html data into dynamic
hi all

i need to convert a website which has static above 2000 articles into dynamic and add