A significant number of these organizations may even upgrade to SE One, SE or even EE, as their needs expand.Īs a small business, I couldn't be happier! Hosting my own sites in HTML DB just got a heck of a lot cheaper for both me and my clients. Many of these organizations will find that they like what they see, and for smaller projects, may need nothing more. Truth be told, Oracle XE is going to force many organizations to take another look at Oracle, based purely on cost. It shouldn't be hard, as moving the HTML DB application is trivial – all that would have to be moved is the data, which isn't all that difficult, either. It would be interesting to see something like running on Oracle XE.
It's not a new set of code – rather, it's the Oracle kernel stripped down and contained in a finite disk & memory space. It was like test driving a Lamborghini - sure, it could be a lot of fun, but at the end of the day, your time is better spent researching cars that you can afford (appologies to anyone who can afford a Lamborghini) With that barrier removed, I think that many shops who went with other databases on purely a cost basis will take another look at Oracle.īut is it really ready for production? While some may argue that remains to be seen, I would think that aside from the initial glitches, yes, it is. While Oracle software has always been available for anyone to download, what was the use if you know that legally you couldn't afford to use it for production. This is one of the largest benefits of Oracle XE – small, compact size with most of the power of the Oracle Database. I was gleefully clicking away, while he sat there, counting the bits as they flew by.
Needless to say, the download of 10gR2 alone took longer than the install of XE. My officemate, at about the same time, decided to install Oracle Enterprise Edition and HTML DB on his laptop, just so he could learn HTML DB and perhaps close a piece of our production environment. Download took about 1 minutes, install another 4-5, and I'm was up & running, HTML DB and all.* Take the situation which happened today: I download Oracle XE and go to install it on my laptop. I suggest you post the same, executed in your database.Lots of activity about Oracle XE over the past couple of days! I figure that I just wouldn't be "cool" if I didn't weigh in on the topic, so here goes: Brilliant! ORA-04098: trigger 'SCOTT.TR6' is invalid and failed re-validationīut, if trigger code is fixed, everything runs OK: SQL> create or replace trigger tr6Ħ values(:old.empno,:old.ename,:old.sal,:old.deptno)
Update emp set sal = 3000 where deptno = 10 SQL> update emp set sal = 3000 where deptno = 10 Warning: Trigger created with compilation errors. It leads to error you got: SQL> create table prac14 as select empno, ename, sal, deptnoĥ insert into prac14 (empno,ename,sal,deptno)Ħ values(:old.empnox,:old.ename,:old.sal,:old.deptno) Trigger intentionally uses :old.empnox, a column which doesn't exist.
Either fix it, or drop it.Ĭheck triggers by running select table_name, trigger_name, trigger_type from user_triggers order by 1, 2
It seems that there's yet another trigger on that table which is invalid. ORA-04098: trigger 'Username.TR' is invalid Note the difference: CREATE OR REPLACE TRIGGER TR6