Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. LeighRiffel

    Enterprise Edition vs. Standard Edition

    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...
  2. LeighRiffel

    Enterprise Edition vs. Standard Edition

    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...
  3. LeighRiffel

    Enterprise Edition vs. Standard Edition

    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...
  4. LeighRiffel

    Enterprise Edition vs. Standard Edition

    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...
  5. LeighRiffel

    Enterprise Manager Job Search

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

    Enterprise Manager Job Search

    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...
  7. LeighRiffel

    Meridian Link Programming Interface

    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...
  8. LeighRiffel

    Oracle Package Errors Design

    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...
  9. LeighRiffel

    Oracle Package Errors Design

    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...
  10. LeighRiffel

    Oracle Package Errors Design

    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...
  11. LeighRiffel

    Oracle Package Errors Design

    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...
  12. LeighRiffel

    Oracle Package Errors Design

    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...
  13. LeighRiffel

    Oracle Package Errors Design

    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...
  14. LeighRiffel

    Oracle Package Errors Design

    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...
  15. LeighRiffel

    Oracle Datatype question.

    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...
  16. LeighRiffel

    Oracle Package Errors Design

    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...
  17. LeighRiffel

    Symposium exporting real-time data to external application

    Thanks.
  18. LeighRiffel

    Is there a way to capture Symonview or Symposium data via TCP/IP?

    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...
  19. LeighRiffel

    Alternative to GRTD

    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.
  20. LeighRiffel

    Symposium exporting real-time data to external application

    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...

Part and Inventory Search

Back
Top