Our daily DTS data pumps normally run without errors, but there are a lot of messages written to the log file. If errors do occur, the messages don't help...

Also there are some big differences between SQL Server and Oracle on locking. This might lead to some differences in application design.

In Oracle, readers see current committed data, which may...

It wouldn't be too hard to use a datetime value to act as the lock. Then if that time stamp is stale, then you can assume that the lock...

Three things:

1. This topic has the wrong date. It is 18 Mar 2005!

2. I think previous poster meant 8 GB.

3. What purpose does the -z switch...

Does someone have quality pseudo code handy on how to implement this scenario properly?

I think it should go something like this:

dirty select to get current locked flag

if not locked

...

One should read the referenced article to the end...

"[Semaphores] have since fallen out of favor except for textbook scenarios."

There are better ways to do this in most programming languages, though...

If cost is an issue, you might consider PostgreSQL.

It is free and its target is Oracle in terms of functionality, so it has stored procedures, etc., and is...

What have we learned?

1. "Books Online" has to be read carefully and is sometimes ambiguous, inconsistent, or wrong.

2. Experimentation and empirical evidence is required to validate claims by...

Also, which driver are you using? Oracle? Microsoft?

It is interesting that the column type/size seems to be a repeat of the first and not related to the remaining columns....

I suggest creating the "temporary" tables ahead of time with the column names that you want.

I do daily importing of data from Oracle, but I had to do a two-step...

I have a system that imports a bunch of CSV files created from Oracle SQL*Plus scripts. I structured the DTS so that is the last/bottom procedure in the structure....

Yes, I checked this out myself before answering. It is an interesting question, but it does appear that "dbo" owns the temporary table. Perhaps in the context of...

I think that there has to be a third "query phrase", which is the main query. If you don't include that one there will be no results at all....

Sorry. I would have but it seems that it was not pertinent to the original post (see JT's last post). Also, I'm neck deep in mapping a government...

Any other non-cursor method seems to be an academic exercise. And looping around a select statement is a poor substitute for a cursor, though it may not use as...