DSXchange

Your sqlldr log shows that all records were processed successfully. However, since you enabled 'SKIP_INDEX_MAINTENANCE' during the direct path load, your Primary Key on the table was left in an unusable status. That issue from the call to sqlldr is what generated the fatal errors in your log. You al...

Not only the same format but one that allows comparison: either the internal numeric format or the ISO external format YYYY-MM-DD.

Post the query and the actual ORA error(s).

rachit82 wrote:Plus one of the old timers read somewhere that Oracle may do away with SQL Loader and he wont sign off on my project for that reason.

That's just crazy talk.

What percentage of the 30M will be deletes? It could conceivably be more efficient to rebuild the table, copying over only the records to be kept. Then rename the tables to swap the new for the old.

So a vertical rather than the horizontal pivot the stage provides. Search the forums for "vertical pivot", the technique has been discussed here a time or two. And please do provide some examples, examples do generally help as long as they are real.

Here as well on an HP-UX machine, under $DSHOME/scripts. Note that it must be run as 'root' which makes it less useful for me, not having root access and all.

Please post in the correct forum! This isn't it. This is the "FAQ Discussion" forum and is reserved for conversations regarding current and future FAQs.

Aha... now we get to the real problem.

Well... I would consider the trashed output file a failure.

No. Well... if it is a true "Reject" link and the job doesn't abort, then yes I suppose. Why assume anything? Easy enough to check.

Use the Director. Make sure your Auto Purge setting are effective. Lastly, that same CLEAR.FILE command can be used, but you'll need to reestablish the Auto Purge settings afterwards.

I almost added my own guess in the first post but thought the OP would get the hint without it and post the error(s) the job generates.

siauchun84 - how in the heck can anyone help you if you keep the details of your problem a secret?

So, not a Server job I take it?