DSXchange

Does the dslockd process clean these up?

We have a bunch of them hanging around my userid from network disconnects and oracle aborts on pl/sql.

How can I automate cleanup?

That worked. Thanks!

NewDDWHash: total 42 drwxrwsr-x 2 myaccount dstage 96 Nov 3 2005 ./ drwxrwsr-x 152 dsadm dstage 5120 Oct 6 15:44 ../ -rw-r--r-- 1 myaccount dstage 0 Nov 3 2005 .Type30 -rw-r--r-- 1 myaccount dstage 12288 Oct 6 05:30 DATA.30 -rw-r--r-- 1 myaccount dstage 4096 Oct 6 05:29 OVER.30 I tried to "chmo...

I've got this error and it appears to be permissions related. I (owner) can create/drop the hash file but my subordinate (user with group permissions) cannot. How do I rectify?

Is there some permissions around the function KeyMgtGetNextValue. If I run a job, they run fine, however if someone else in my group runs that job, the number is -1 (over and over).

Just grabbed the wrong file.

Thanks!

On a related note...

How does one re-create this file (D_RT_STATUS)?

Found the answer, tricky to search on:

viewtopic.php?t=93264&highlight=drtstatus

Please close this thread.

This is odd. I added some new jobs to a project of all Multiple Instance jobs, now I can only see "Compiled" and not each instance of the job. Is there some setting to view?

OK, so load 13 files then on the last job, loop throught the files and insert/update against the table.

Is one file more optimized than another (hash, sequential, ftp plugin, complex flat file, etc)?

I'm interested in the background table option. Currently, I have 13 jobs that update this one table each night. Preferably, I'd like to store the transactions from those 13 jobs somewhere once, then apply all the transactions to both tables. What are my options? Our ETL is: 1000's of source Oracle t...

Thanks for this Abraham. It sounds like I'll need to devise a list of inserts, updates and deletes to be submitted to a job.

Hi all! Our warehouse has customers across the globe, keeping the fact table online 24/7 is the new mandate, however those pesky bitmaps make this difficult (we're on Oracle 9i). We've decided to load a temp table then switch it out with the real one once the etl is done, that way the table is not d...

I guess not.

<----

I paid this morning too. I got an email welcoming me as a charter member, anything else I need to do?