Search results for query: *

hey e.b. yeah, I am pretty sure that will work too, but I was hoping for something a little more elegant and less clunky. That is a very very rough and tough way to do something that is very very simple to do using SQL (and is used quite extensively) in other rdbms systems. If I keep using...

How horrible. Ah well. I will look to Postgres (since they now have a full Windows port)... if it doesn't have it, back to MySQL. At least it is free as in beer. Thanks for the info! Cheers.

I am trying to write some pseudo dynamic sql to generate a script. It is something I have done much of in Oracle and SQL Server, but I can't figure out the data dictionary for MySQL Example (what I would do in Oracle): select "select " || column_name || " from " || table_name || ";" from...

Well... one, obviously there is a problem, or people would not be asking about it. Or are you saying people here are not intelligent. I would say there is a lot of experience here. A lot of the folks posting and replying here are not newbies. In fact, I would say that a good number probably...

And if you have a large volume of data that needs to be fed into the temporary table you will have the same problem.

I forgot to add this: Can I make a procedure in Java, call it from the trigger, and have the java procedure do what-ever web page crawling is necessary? Hoping I am making sense. :-)

This is an odd request... I have a friend who asked if there was a way to pull data from a web page from within a trigger or stored procedure using a 'get' type of command and specifying a URL. It sounded pretty odd to me... and very unlikely, but what the heck, there are a lot of folks with...

p.s. holy crap... the thread that never dies... I suspect that eventually we can publish this as a book: "The ORA-01555 Affair" or "How ORA-01555 Gave Me Hearburn".

I would suspect that it is because data warehouses are usually updated/inserted very infrequently relative to an OLTP database. Many times just once a day, when the past days activities are loaded. Once the data is loaded, the data warehouse is used 99% of the time for query only. This means...

This is for Chris... We have a DBA who thinks otherwise and I wanted to hear some other opinions. I am also looking through documentation.

I am trying to get some information on the FIRST_ROWS optimizer option in Oracle 9i. I know that this option tells the optimizer to return the first row of the result set as fast as possible. However, I know that in many product's cost based optimizers, that when the first rows type of option...

Here is something interesting from the Oracle manual for 8i: "Changed data blocks queried by a read-only transaction are reconstructed using data from rollback segments. Therefore, long running read-only transactions sometimes receive a "snapshot too old" error (ORA-01555)...

Hey Dima, I thought about that too. I think you are right about this for most users. In our case the consistancy is not as much of an issue. This operation is repeated over and over again all day in a near real time data feed. This means if we made a large data consitant read this time...

Hey Dave, We have determined that we have a way to 'chunk' up our data. That is, grab the data that makes up the report in chunks, rather than all at once. This reduces the amount of data returned from the query making it less likely that rollback segment becomes an issue, since it will...

Ya... I get it now. Trouble is that this is part of an enterprise solutions that is really really huge. This means that usually I don't have access to how many rollback segments that we have or how they are named. And likely I won't know if they add or decrease the number of rollback...

So now I am at a loss. The short of it is that the only DML is an insert into a temp table. What confuses me is that I thought temp tables don't require the use of a rollback seqment since operations on them are not logged. For background, the error occurs when running a complex report...

Hi Guys, sorry for tagging on to the end of this, but it sound like the folks here might have an answer to a very similar issue. I am getting the same error message (ORA-01555: snapshot too old... rollback blah blah blah), but it is relating to the use of a global temporary table. I don't...