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.
|
13h |
comment |
BLOB storage in rows BLOBs are actually stored this way by Oracle already, ie out-of-line in a separate "table" (called a Segment by Oracle). |
|
2d |
comment |
How do you get the explain plan? If you have followed a course with Jonathan Lewis, then you will know that there are something like 8 different ways to get an execution plan out of Oracle. Please upvote this comment if you want me to add an answer listing all the different methods. |
|
May 16 |
comment |
Tablespace on ephemeral storage Great question! One can certainly take a tablespace offline, see docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces005.htm But I suspect the easiest way to automate this would be to drop the tablespaces before shutting down the Oracle instance. Then there's the issue of what would happen on a machine crash. I'm more of a "logical DBA" so I'll leave it to a "physical DBA" to answer this question. |
|
May 15 |
answered | Are all matching indexes (indices) searched for a query? |
|
May 14 |
awarded | Caucus |
|
May 8 |
comment |
Restrict access for Windows administrator in PostgreSQL So the answer is no. The Windows administrator on the machine that Postgres (or any software) is installed on can do anything to the installed software and thereby get access. |
|
May 7 |
comment |
Oracle 10XE: Stop schemas seeing the all_users table? A bit expensive to host too, as Oracle XE's license limits you to one instance per "server"... see docs.oracle.com/cd/B25329_01/doc/license.102/b25456/… |
|
May 7 |
comment |
How to design this database to avoid cyclic dependency? NB The relational model supports doing two inserts or updates as one atomic operation, it's a real shame this isn't supported in SQL (as deferred constraints -- even though I suggested them -- are quite horrible). |
|
May 6 |
answered | Transfer data from DB2 to Oracle |
|
May 6 |
answered | How should permissions for anonymous users be modelled? |
|
May 6 |
comment |
Oracle Connection Manager cman.ora startup Does this help? docs.oracle.com/cd/E11882_01/network.112/e10836/… |
|
May 6 |
revised |
How to connect to Oracle 11g using “Navicat for Oracle”? edited tags |
|
May 6 |
answered | How to connect to Oracle 11g using “Navicat for Oracle”? |
|
May 6 |
comment |
How to design this database to avoid cyclic dependency? You could always used deferred constraints if your DBMS supports them. |
|
May 3 |
comment |
What's the best way to backup DB files via network on Linux and Solaris machines? NB Also configure rman to backup your controlfile to the flash recover area! |
|
May 3 |
answered | What's the best way to backup DB files via network on Linux and Solaris machines? |
|
May 3 |
comment |
NLS_TIMESTAMP_FORMAT changing automatically and randomlly If it's only after each login in SQL*Plus then the most logical place it's happening is in glogin.sql or login.sql (as haki mentions in his answer). See also adp-gmbh.ch/ora/sqlplus/login.html |
|
May 3 |
revised |
NLS_TIMESTAMP_FORMAT changing automatically and randomlly grammar, spelling. |
|
May 3 |
suggested | suggested edit on NLS_TIMESTAMP_FORMAT changing automatically and randomlly |
|
May 2 |
comment |
NLS_TIMESTAMP_FORMAT changing automatically and randomlly What do you mean randomly? After login? Or on each login? |
