meta user
network profile
| bio | website | google.com |
|---|---|---|
| location | Peak District National Park, United Kingdom | |
| age | 35 | |
| visits | member for | 1 year, 4 months |
| seen | 4 hours ago | |
| stats | profile views | 579 |
Oracle DBA, Unix admin.
Available for employment.
|
May 2 |
comment |
Compare dates problems What dates are you actually looking for in the resultset though? Please edit your answer and explain in plan English. In the above example, do you want '2013/05/16 23:59:59' to be included, for example? |
|
May 2 |
comment |
NLS_TIMESTAMP_FORMAT changing automatically and randomlly When is it differing? Are you aware that tools/libraries are able to change it with an "alter session" and this may be happening in the background (depending on the tool), upon login for example. |
|
May 2 |
revised |
If I SET ARRAYSIZE 1 in SQL*Plus, the records are still fetched in pairs. Why? deleted 4809 characters in body |
|
May 1 |
comment |
Oracle Express intermittently stops responding, requiring a OS reboot to fix No worries. Ask more questions on the site if you need any more help. We're here to help :) |
|
May 1 |
answered | Oracle Express intermittently stops responding, requiring a OS reboot to fix |
|
May 1 |
comment |
Oracle Express intermittently stops responding, requiring a OS reboot to fix That's why. It's a known problem. 32-bit Oracle XE isn't supported on 64-bit Windows. |
|
May 1 |
comment |
Oracle Express intermittently stops responding, requiring a OS reboot to fix Are you running 64-bit Windows perchance? |
|
May 1 |
comment |
Oracle Express intermittently stops responding, requiring a OS reboot to fix Your edit points to this ss64.com/nt/syntax-desktopheap.html - that may fix it. Is it also possible your app is leaking handles or something? |
|
May 1 |
comment |
Oracle Express intermittently stops responding, requiring a OS reboot to fix How odd. Is there anything in the database alert.log? |
|
May 1 |
answered | How to load the Adventureworks database into Oracle? |
|
May 1 |
comment |
Windows Server 2008 R2, Active Directory, and Oracle Database Server Why do you need Active Directory to act as a proxy for database connections? Doesn't make a great deal of sense. |
|
Apr 30 |
comment |
information_schema.table_constraints doesn't exist error in MySQL The "dev_salescase" part is a bit of a giveaway.... |
|
Apr 29 |
comment |
Windows Server 2008 R2, Active Directory, and Oracle Database Server What are you really asking? You want clients to use AD authentication? Connecting through AD makes no sense. |
|
Apr 29 |
comment |
how to check which background process are running in my oracle database? What OS? Windows/Linux/AIX .... ? |
|
Apr 29 |
comment |
Why does DBMS_UTILITY.COMPILE_SCHEMA break function-based indexes? I do also wonder if TO_NUMBER has been overlooked |
|
Apr 28 |
comment |
How to use CREATE TABLE … AS with Primary Key in SQLite You can't do it with CTAS. If you want PKs etc, you'll have to pre-create, then insert. It's trivial to get the DDL for an existing table. |
|
Apr 28 |
answered | How to use CREATE TABLE … AS with Primary Key in SQLite |
|
Apr 26 |
comment |
Network Databases en.wikipedia.org/wiki/CODASYL if anyone was wondering what the OP is on about |
|
Apr 25 |
comment |
Efficient way to perform approximated search? What's the cardinality of the evnt_sec column? How many evnt_sec per (id1,id2)? What indexes are already in place? Is such an approximate match likely to cause multiple rows returned because of its approximateness (not that it's a word :P )? (IE: Is the data per id1,id2 close together, as defined by evnt_sec?) |
|
Apr 25 |
comment |
Oracle Connection Manager Configuration What's the output from lsnrctl status on the database box? Edit your question with the output please. |
