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

Output Buffering question
Hi all,

I've been trying to wrap my head around output buffering. So far I've found tons of

Help, Base64 encoding url and decoding server side.
Hello everyone, i have a website with videos and games and also provide an embed code which people c

Issues: PHP Forms -Clearing
I've tried looking online before actually asking for help, but I've been looking for about the past

PHP MySQL Return Results Issue
Hi guys,

I'm running joomla and made a module which is using ajax.
Basically i just have a

Multiple forms on the same page (safari)
Hello everyone,

I have 3 forms on the same page, that opens in a new window and submits to a

filesize() returns 0
I have a socket program that runs in an infinite loop, listening for connections, in this socket I h

Sql and php order list script problems
Hi im having a few problems with trying to get the coding right on a orders list ive done (or trying

Sessions work for me and not others?
I'm having a bit of bad luck with sessions. In the past they have worked fine for me, but this time

Weird MySQL error, why am I recieving this?
PHP Code:


<?php require "global_settings.php"; ?>
<titl

Help With editting and deleting form
Hallo !!

So look at this image :

http://img194.imageshack.us/img194/8272/snapshot5f.pn