Tag Archives: oracle

rails and avoiding oracle sequences at insert

%B %e%q, %Y – %I:%M %p

When using Rails on top of an Oracle database, you use the oracle enhanced activerecord adapter. This adapter (or Rails) has one weird side-effect: there is no way to avoid using a sequence when inserting a new record. But, in this comment, Raimonds Simanovskis hints at the solution. In an initializer you write: … and [...]

By nathanvda | Posted in Uncategorized | Also tagged , | Comments (0)

Spatial DB Advisor

%B %e%q, %Y – %I:%M %p

PL/SQL package: lessons learned Working with Oracle Spatial a lot, I found a great source of information in the Spatial DB Advisor, which besides a lot of interesting articles, also offers his source-code and PL/SQL packages for free. The site is not very user-friendly (trouble of seeing the threes through the wood), as finding the [...]

By nathanvda | Posted in Uncategorized | Also tagged , , | Comments (0)

showing international or accented characters

%B %e%q, %Y – %I:%M %p

I am now working in Ruby on Rails for about a month. I have done a few smaller things before, investigating, trying out; but now I am really building a full application site in Rails! It feels great :) But of course, just starting out in such a new environment, both ruby and rails, I [...]

By nathanvda | Posted in Uncategorized | Also tagged , | Comments (0)

ORA-01031 error when creating database

%B %e%q, %Y – %I:%M %p

At my new job I am back to administering Oracle. The last time I had to do any dba-job, they were still using Oracle 7 :) At my current job, the IT-department can be summed up in one word: me! So, now i have to do everything again. So today, i was trying to get [...]

By nathanvda | Posted in Uncategorized | Also tagged , | Comments (0)

Oracle 10 Troubles –continued

%B %e%q, %Y – %I:%M %p

We had more than a few troubles migrating to Oracle 10, in our production environment. We are using a clustered server, with 3 nodes, so it should be blindingly fast. I’ll sum up our biggest issues (we had) : Sequences : we used a sequence to make sure the messages we send, can be ordered. [...]

By nathanvda | Posted in Uncategorized | Also tagged , | Comments (0)