Search results for query: *

These are great ideas. Thanks thargtheslayer and tekdudedude. I'll see if I can carve out some time to do just as you suggest. It will be difficult to pin them down on recovery time objectives, but I may be able to give them some scenarios for comparison showing our current recovery times...

All good advice. I agree with these comments and the point of view from which they were written. I understand that enterprise edition is not a silver bullet, but I believe it would be extremely useful in our environment. I also know there is no definitive answer to the size question and that...

Thanks for these answers. Partitioning is one of the big reasons I want to move to enterprise edition, but there are many other reasons including online index rebuilds, flashback table, block level media recovery, Fine-Grained auditing, and several other things. We don't have a large number of...

Thanks for asking this question tekdudedude as I am after the same type of information. We currently have three standard edition databases (six if you include development versions) and are looking to get another. The current databases are 80GB, 70GB, and 50GB. The new database is expected to...

Thank you for the reply. You are correct; it does not really help with my question that I can see.

I just inherited a database with a bunch of jobs in Oracle Enterprise Manager. Some have over a dozen tasks each and most tasks run multiple procedures. Is there an easy way to find the job that does a particular procedure call? I would expect this to be in the data dictionary, but so far I...

We are trying to get call destination information from our Nortel Succession 1000M switch into an in-house application. Specifically the ANI of the call and the Phone set the call was sent to. We have Symposium 4.2 and have looked at CT solutions from both Nortel and Envox, but would like a...

Tharg, the database is too large to make a replication scheme practical not from a storage standpoint, but from an infrustructure/syncronization standpoint. Dima, I have written something such as what you suggest. I thought about doing it in an autonomous transaction, but hadn't yet decided...

Tharg, No, I cannot add constraints, indexes, or triggers. What I can do is write views and packages in a seperate schema that access the data in the schema controlled by the original application just as you suggest. No, the primary application was not written in Oracle. It was written in...

Dima, Yes, you are correct. There will be situations in which the interdependancy of the data will require me to immediatly stop processing, but that will not always be the case. Consider a procedure that accepts two parameters that update different fields in two unrelated tables. If an...

Tharg, I didn't mean to imply that I planned to handle any business rule violations by throwing exceptions, on the contrary I agree that trying to make this work that way would be a nightmare. Alas, if only I could use Referential Integrity. We have a nasty primary application that maintains...

Tharg, I have downloaded PL/Vision and perused the documentation. It looks like I am trying to write something very similar to their logging functionality. It seems like it would be simpler just to write the small peice I need rather than modify this monolithic infrastructure to handle the...

Dima, I have looked at DBMS_UTILITY.FORMAT_ERROR_STACK and it doesn't look like it will do what I need. There errors I will be detecting are not part of a call chain and therefore will not be stacked. I could have one procedure that could detect five different error conditions. The first...

I'll look at DBMS_UTILITY.FORMAT_ERROR_STACK and PL/Vision as well as soon as I get a chance. Tharg, Multiple applications will be calling this package and I'd rather program the buisness logic once on the package side rather than multiple times in each application. I suppose you could call...

I haven't used one before, but it seems like an instead of trigger would be useful here. You could point your application at a veiw of your table rather than the table itself. The view could be defined as follows: select STAT, to_char(VARATAT,'90.00') varastat from TEST_TAB; You could then...

I am writing an Oracle package to be used as an interface to several related tables. I am attempting to design the package such that if a particular procedure or set of procedures are called that have expected, non-fatal errors, that all the errors are returned and not just the first one...

Thanks.

Yes, this is exactly what we have done. I created an application that reads the Symonview packets off the network and inserts the data into our Oracle database. We currently do this only for playing hold time information on our Edify IVR, but I think it would be relatively easy to create an...

I beleive there was a solution for this posted in anther thread involving copying the web page source for each billboard and placing them in frames within a new web page. Someone familiar with web programming should be able to do this very easily.

Yes, I beleive it is. The Symposium server is actually handled by our Telecommunications department while I am responsible for our Edify IVR. I had to do some integration with Symposium to get hold time information because our old solution of reading it programatically from DWC keys no longer...