meta user
network profile
| bio | website | datajini.com |
|---|---|---|
| location | Frösön, Sweden | |
| age | 40 | |
| visits | member for | 10 months |
| seen | 1 hour ago | |
| stats | profile views | 54 |
I'm an Oracle Database Specialist at DataJini, an Oracle consultancy that specialises in building solutions using MDD techniques.
|
Apr 16 |
comment |
How to disable oracle's MAX_ENABLED_ROLES limit I also read: "The MAX_ENABLED_ROLES parameter is deprecated. It is retained for backward compatibility only." |
|
Apr 16 |
comment |
How to disable oracle's MAX_ENABLED_ROLES limit What's the problem? |
|
Apr 16 |
answered | How to disable oracle's MAX_ENABLED_ROLES limit |
|
Apr 16 |
comment |
PostgreSQL cannot start after replacing contents inside its Data folder "Permission denied". Have you checked the obvious? |
|
Apr 15 |
comment |
Approach for a 2,000 table migration Editted original to include comment on mapping from old to new. Inadvertently enabled community wiki, but that's OK too :-) |
|
Apr 15 |
revised |
Approach for a 2,000 table migration Added comment on mapping data from old to new. |
|
Apr 15 |
comment |
“Variant” values structure and their use for multiple columns If this is a metadata storage solution, why will there be multiple columns with the same variant structure? |
|
Apr 15 |
comment |
“Variant” values structure and their use for multiple columns The real problem with nulls is that it forces more interpretation of data which results in A) increase in code and complexity to cater for the different cases, and B) the resulting reduced value of the data for the business using it. In the case here all columns that are really used are not null, enforced by the check constraint. And, yes, I prefer to avoid too many tables for this pattern. |
|
Apr 15 |
comment |
“Variant” values structure and their use for multiple columns Well, I probably would use the single table approach and constraints as shown in my answer below. |
|
Apr 15 |
answered | “Variant” values structure and their use for multiple columns |
|
Apr 15 |
comment |
“Variant” values structure and their use for multiple columns I fail to understand when you would need a physical column to store a variant type. Please give us the real example. |
|
Apr 15 |
answered | Approach for a 2,000 table migration |
|
Apr 15 |
comment |
Approach for a 2,000 table migration Personally I think that having no information about the current database is a blessing in disguise: the current system is what is, not the documentation thereof. |
|
Apr 12 |
revised |
Why are constraints applied in the database rather than the code? added 198 characters in body |
|
Apr 12 |
answered | Why are constraints applied in the database rather than the code? |
|
Apr 12 |
comment |
Use CASE to select columns in UPDATE query? Be aware also that updating a column to the same value will cause redo to be created, see orainternals.wordpress.com/2010/11/04/… |
|
Apr 12 |
answered | Use CASE to select columns in UPDATE query? |
|
Apr 12 |
awarded | Citizen Patrol |
|
Apr 12 |
comment |
best database for a real estate system Trillions of rows? I don't think so. |
|
Apr 11 |
comment |
Column or new table Another way of thinking about this: How are you going to make sure that no-one enters the same school using 2 different spellings? While making it a separate table with a foreign key won't stop this happening it will greatly reduce the incidence of this sort of "dirty data". |
