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

Did you know?Explore Trending and Topic pages for more stories like this.
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.
No comments posted yet

Your Answer:

Login to answer
53 Like 25 Dislike
Previous forums Next forums
Other forums

Entering Data Problem
Code: $result = mysql_query("SELECT * FROM flights");
while ($row = mysql_fetch_array($

use an array from 1 class in a second class
I have a class that adds data to an array

Then I have a second class and I need to check if t

Adding to the next element in a multidimensional array
Hi, I'm trying to add a value to $node->field_spaces['nid'] where x is the next available spo

Regarding accessing SQL query issued by any user in Oracle 10g
Hi all,
i want to know the queries issued by various users accessing a database...

php problem?
I don't think I'm stupid, but maybe I am.

I am working on a sit for a friend I am try to put

help with image upload code
Hello,

right now this code I have resizes images and then places them into the uploads folder

Thread in PHP
Thread in PHP
Some basic use and basic code for thread in php
This is my question?

How to make a input/output field with multiple lines
Hello.
I put a input/output field on the screen but I could not change height of it. I need to

building a function with multiple outputs
I want to build a function that has multiple outputs.

I know but am not to sure how I should

Combining Two Queries
I have two scripts that each work fine by themselves. One is a search script with a variable that de

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash