Red-Ringed Tupperware Party with (ineffective) Tin Foil Hats

Pete, loved the squirrel shots!

You all know that friday the 13th is considered a bad luck day right?

Well officially I am now changing that to wednesday the 13th.

Everything that could go wrong yesterday at work did go wrong and resulted in a restore of a production database

Bad day on the frontier, eh?

I'm singing "Can't get no satisfaction" today. Not as bad as yours, just that we did all the work and it feels pointless.

Anyway I'm out for the evening so I am not too worried bout it

What happened was I added a new table to an application that ha sthe database on Oracle. I thought that to be really trivial and low low low risk. I have added tables before.

But because it was a copy of an existing table the new table has some references to the old which required some special handling. Without that special handling the existing table was deleted. I never thought that could happen. Lesson learned for future.

Lightstream wrote in post #3375157
Bad day on the frontier, eh?

I'm singing "Can't get no satisfaction" today. Not as bad as yours, just that we did all the work and it feels pointless.

Anyway I'm out for the evening so I am not too worried bout it

I have been there too in my old job.

tommykjensen wrote in post #3375178
I have been there too in my old job.

This current posting that I'm on has far more of those moments than it should. Good thing is that it ends sometime and I get to move on. It'll be good to be back home

Oh man is Adobe support stupid.

When I originally started using PS I created an account on Adobe.com not knowing better I created it as an USA account and I registered my PSCS2 with that.

Then I wanted to order the CS3 upgrade and could not do that because it was USA and I could not specify my danish address.

So I created a support case asking them to change the country on the account.

They refused and said I should create a new danish account.

Before I did that I asked then what about the CS2 I had registered on the USA account. Can they move it to the danish account.

No response.

Then I created the danish account and tried to register CS2. And of course it could not be done so I told Adobe that.

They then said I had to call USA and then I would be asked to fax them details about both account on paper with my company letterhead then they could mnerge the 2 accounts. I refused to do that for 2 reasons. Why the heck should I call from Denmark to USA to get this solved, second I am a private person without paper wearing my own letterhead and I would certainly not create one for this.

This went back and forth daily and all I got from Adobe was semi-automated responses. They even closed the case 2 times. I reopened it every time still demanding they fix it. Before they closed the case they also started to say hey you are not from usa so you need to contact local support. Huhhh why didn't they say that in the first place instead of wasting 2 weeks. Ohh well I created a local support case and nothing happens for a week.

Now all of the sudden I got a response from UK saying that they can't merge the accounts but they could transfer the serial number to my danish account. What the heck??? Stupid timewasting Adobe support. They could easily have done that from the beginning.

And then Adobe wonders why so many use illegal copies of their software......

tommykjensen wrote in post #3375172
What happened was I added a new table to an application that ha sthe database on Oracle. I thought that to be really trivial and low low low risk. I have added tables before.

But because it was a copy of an existing table the new table has some references to the old which required some special handling. Without that special handling the existing table was deleted. I never thought that could happen. Lesson learned for future.

Oracle I did a year course on oracle sql last year. Hate it!

Makes me glad I bought Elements, at a staggering cost of $99 - and it came bundled with a Graphire4 tablet too

tommykjensen wrote in post #3375172
What happened was I added a new table to an application that ha sthe database on Oracle. I thought that to be really trivial and low low low risk. I have added tables before.

But because it was a copy of an existing table the new table has some references to the old which required some special handling. Without that special handling the existing table was deleted. I never thought that could happen. Lesson learned for future.

Have the triggers been biting? (Oracle 10G sufferer here)

MySQL rocks my boat. Sure, not as feature packed I agree, maybe not as high performance, I agree, but the price is right (boss/finance/CEO agree) and it is quite tame-able.

MySQL is open source/free.

Lightstream wrote in post #3375276
Have the triggers been biting? (Oracle 10G sufferer here)

I don't know. But I do know it was not an Oracle issue but an issue with the application that created the table. The application has its own propritary database format as flat files. And when creating new tables they start in that database and then need to be moved to Oracle. And it was in that process the problem occurred. Since the new table actually was a copy of an existing it should be handled in a special way because the table contained references to the old one and they needed to be changed during the move. That was not done so a DROP was issue towards the existing table.

Adcuz wrote in post #3375285
MySQL is open source/free.

Unfortunately the application I am working with only Supports Oracle, MS SQL and DB2 and the customer I work for has choosen Oracle.

Sounds really rough, Tommy. I feel for you. Hope it all got sorted out with the minimum of user rage...

tommykjensen wrote in post #3375292
Unfortunately the application I am working with only Supports Oracle, MS SQL and DB2 and the customer I work for has choosen Oracle.

Between all of the above, give me Oracle

Sorry to hear you got bitten by poor app design. It's not really Oracle's fault. It is actually quite a reliable/decent DB, it's just that some admin functions get complicated at times.