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

Referential Integrity problem when inserting into 2 tables at same time
Hello Everyone,

Im relativity new to PHP and MySQL and i have come up against a problem. i h

form variables from database help.
Hi all,

I would like to have a form that gives you options based on the results of an mysql q

parameter passing issue on function
Well I thought I had created a pretty slick web page, using ?page and $_GET to load pages which wher

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

What are the two different files you download to update kernel?
What are the two different files you download to update kernel?

problem with sql querry in php script
Hello guys,

What I want to do is I want to read out a csv file and then but te conent ot the

Impact of movement type 412 E on MAP
Hi

Usage of movement type 412 E is causing huge change in MAP .

Is there any r

mysql query with single quotes in a variable
$sitedetails = "INSERT INTO vars (address, sitename, description, ownername, theme) VALUES ('$u

Need help to identify this error please
:confused:Can anyone help me tell what this error message means? Maybe tell me where to look to fix

Need Reporting Advice
My SQL server doesn't support MS SQL reporting services that comes with SQL Enterprise or Express. T