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.

No comments posted yet

Your Answer:

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

Problem Dereferencing
With these types and tables:

CREATE TYPE MANAGER AS OBJECT (
MGR_ID INTEGER,

dropdown box help - open php files to textarea
Hi, I am using tinymce to edit content located in several php files. The code I attached works but i

Reduce redundancies in switch functions?
Hello all! I somewhat new to PHP, and was wondering if anyone could give some suggestions on a swit

cURL error
So here is my code... I got it off of here... http://www.youtube.com/watch?v=XcgQUsorF_8
Because

PEAR Email Attachment w/ $gpg
I have no issues with this code if I take out the attachement section and include the info in the em

Formatting echo from database
So I have a database that stores First and last names, then echos them back to a website, as of now

Join Query Help
Hi all,

I am having problems with the below code, which we shall call 'my first join query'!

email CODING Problem
Email coding problem.

I need to send a section of the info to $tf and the same as a Cc to $em

PHP webpage & array print issue
I have this code running, and it works perfectly … however, see my bottom bit about what I see

COde for a Cc
I'm not receiving $ft as a Cc. Why is that??

$to = "$email";
$headers = "Fr

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