meta user
network profile
| bio | website | datajini.com |
|---|---|---|
| location | Frösön, Sweden | |
| age | 40 | |
| visits | member for | 10 months |
| seen | 27 mins 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 18 |
comment |
Is it possible in Oracle to trace SQL statements that result in errors? I understand that this will only trace SQL calls made from PL/SQL but please let me know if this is not the case. |
|
Apr 18 |
comment |
Is it possible in Oracle to trace SQL statements that result in errors? The PSOUG link has an example of how to capture the SQL statement the session was executing when the error occurred. DBMS_TRACE will only trace PL/SQL code so if you have a Java or .Net app for example then this won't help you. |
|
Apr 18 |
comment |
PostgreSQL, How to keep only one schema? You used CREATE SCHEMA other_schema; which returned an error to prove that schematest cannot create a new schema. I would've expected CREATE TABLE public.test(col integer); or something similar to prove that schematest can create objects in public. |
|
Apr 18 |
comment |
PostgreSQL, How to keep only one schema? How does GRANT CREATE ON SCHEMA public TO schematest; prove the ability of schematest to create objects in the schema public? |
|
Apr 18 |
answered | Is it possible in Oracle to trace SQL statements that result in errors? |
|
Apr 17 |
comment |
look for missing datetime records in database You say "no looping" but IMHO the key to making the switch between procedural thinking and set-based thinking is the realisation that a database table of records 1..n can be used in exactly the same way as a for loop in a procedural language. |
|
Apr 17 |
revised |
Using postgres with the command line without pgAdmin Typos, grammar. |
|
Apr 17 |
revised |
Can I rely on the order of colums on an index generated by Database tuning advisor edited tags |
|
Apr 17 |
revised |
Can I rely on the order of colums on an index generated by Database tuning advisor edited tags |
|
Apr 17 |
answered | “Variant” values structure and their use for multiple columns |
|
Apr 17 |
suggested | suggested edit on Using postgres with the command line without pgAdmin |
|
Apr 17 |
comment |
Using postgres with the command line without pgAdmin See support.apple.com/kb/ht5017?viewlocale=en_us&locale=en_us for information about hiding users in Mac OS X. |
|
Apr 17 |
answered | How to check if Oracle DB process is running in Unix and where Oracle DB is installed |
|
Apr 16 |
comment |
How do I execute an Oracle SQL script without sqlplus hanging on me? I think you can do this under Linux/Unix when you embed the SQL commands in a shell script and pipe them into a SQL*Plus instance. |
|
Apr 16 |
awarded | Nice Answer |
|
Apr 16 |
comment |
postgres deadlock without explicit locking I think most DBMSes will get a deadlock for this scenario. |
|
Apr 16 |
answered | postgres deadlock without explicit locking |
|
Apr 16 |
comment |
In Postgresql, is it possible to change the maximum number of columns a table can have? PostgreSQL is open source, so yes, it is possible to change the maximum number of columns a table can have. |
|
Apr 16 |
comment |
How to disable oracle's MAX_ENABLED_ROLES limit Oops, I missed that (and I just got new glasses too). It's a bit of a mess, but in explicit answer to the original poster, it's possible to "expand the value of limitation" to 148. |
|
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." |
