Search results for query: *

OK, I see what you are saying. I will look at that. Thanks.

Bill - if I am understanding your point correct...the table that changes is about 90 columns which contain anything and everything about our entities. The IDs do not change, but rather various information about the entities...for instance their home address, email, marriage status, etc. We do...

Mufasa - I saw a slight improvement in the delete after running those lines of code. About 10 minute improvement on the overall procedure, and the delete takes the bulk of that. Dagon - I will give your suggestion a try as well and post the results. Thank you both so much for your help! This...

Thank you! I will run this tomorrow am and post the results.

It varies, but here is a current approximation (from a test run today) 4071:272534 The table being deleted from is indexed, very well at that. But I also suspect that continuously doing these deletes/inserts on the large table (90 columns) may be wreaking havoc as well. But the only hang ups...

No, but it is simply a one column table with ids. The ids in the temp table drive the delete and insert. So, would an index on this one column be the way to go?

Yes, that is exactly it.

We have table A which contains a great deal of information about our "entities" (id, name, address, etc.) in a specific format for the other system we send the information to and various reports, procedures etc. We can't change how this table is/the overall procedure is done because of the...

The counts do not match because we refresh the test database nightly and there is constantly changes being made to the entity and handling table from our users. We do many loads in the morning as well into production. But I did verify a select group of the entities which appear in the production...

I am logged in as the user who owns the tables, we only have one schema. This also happens with another select query, which is much simpler, so this tells me there has got to be something different between the two databases because the data is identical.

I am running a select statement on our production database and our testing database. On the production database this select returns results, but none on the testing database. I have verified that the tables/data on both are identical, so I am stumped as to why the testing database returns no...

Thank you. That was my initial thought, I just needed to reaffirm that.

One of our Linux partitions is running into space issues and there are a couple databases on this partition that are not needed and would free up a significant amount of space. Instead of blowing the db's away entirely, I'd like to somehow back them up (onto a different partition) just in case...

Thank You!

I hope this is the right place for this. I did not see an Oracle Sql forum. I'm having a mental block today. I am creating a table as select from a few other tables. My problem is, a couple of the columns that I would like included in this table cannot be selected from another table and I would...

Thank you so much, I will try this out today. Your a life saver :o)

Thank you, I'll check back then.

Thanks for the reply...Well seeing I don't know a thing about macros it would be much appreciated if you would send me one, when you get the chance. Thanks again, Christina

Right now I am in testing mode on a updated test database (we are migrating from Costpoint 4.0 to 5.1). I have upgraded my Impromptu catalogs and placed them in a different directory (catalogs73). I attempted to use the report upgrade utility for all my impromptu reports, again they are in a...

This may be a long shot...but here goes... I am using Impromptu 6.0 We have about 40 catalogs and over a thousand reports. Unfortunatly nothing was ever cleaned up for years and years but now I have to upgrade everything and I really want to clean up any unused reports/catalogs. It is a mess. So...