| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hi,
Is there a good way to convert a date to the Unixtimestamp? We need
to do this. I used the function below, but our developers are tells
us it...
The Magnet
|
02-28-2011 04:51 AM
Robert Klemme  | 3 | 4 |
| | | International Business Intelligence (BI) software vendor, Yellowfin,
has confirmed its place as a leader in Mobile BI, blitzing Howard
Dresner’s...
JTP PR
|
02-27-2011 06:30 AM
JTP PR | 0 | 1 |
| | | Hi,
We have a query which has a surprising plan. I assume Oracle considered
the right plan, but rejected it. Is there any way to tell it that...
Tom Anderson
|
02-26-2011 05:19 AM
Jonathan Lewis | 3 | 4 |
| | | On 16.02.2011 20:24, Tom Anderson wrote:
Well, OR-Mappers are typically not very fast since they tend to handle
every single instance individually...
Robert Klemme
|
02-25-2011 11:57 AM
Tom Anderson | 6 | 7 |
| | | I converted a single instance to RAC manually. I re-created the control
file, I added & enabled an additional logfile thread, additional undo
space...
Mladen Gogala
|
02-25-2011 11:48 AM
Mladen Gogala | 2 | 3 |
| | | Hi,
i have a strange effect, since we added a select ... from ... start
with ... connect by ... SQL stmt.
Oracle doesn't tune anymore for parallel...
Frank Bergemann
|
02-24-2011 02:14 AM
Frank Bergemann | 0 | 1 |
| | | Hi,
Oracle 9.2.0.8 Enterprise (Linux)
MySQL (Windows)
Could anyone provide me with a solution(s) to export/migrate schemas
from Oracle to...
trub3101
|
02-23-2011 10:29 PM
Steve Howard | 6 | 7 |
| | | All,
I hope this is not too vague of a question, but let me know if better
clarification is needed. I am going to be replacing a...
seanD
|
02-23-2011 09:26 AM
Mark D Powell | 3 | 4 |
| | | Dear All,
Let me know if you have anyone available for the below position,
please send resumes with rate, location and contact details:
Job Title:...
Isaac
|
02-21-2011 01:02 PM
Mladen Gogala | 1 | 2 |
| | | Oracle 11.1.? on Linux
We are using partitioned tables, partitioning by interval, so partitions
are automatically created as we need them. Part of...
Adrian
|
02-20-2011 05:06 PM
John Hurley | 5 | 6 |
| | | I was comparing 2 SQL statements which produce the same result. Here are
the statements:
with e(empno,mgr,lev) as (
select empno,mgr,1 from emp...
Mladen Gogala
|
02-19-2011 01:52 PM
Randolf Geist | 6 | 7 |
| | | Just got a call from some Oracle customer rep with a difficult Indian
accent, telling me support prices will increase 10% for those who
don't upgrade...
joel garry
|
02-18-2011 06:33 PM
John Hurley | 11 | 12 |
| | | Has anyone upgraded to 11.2.0.2 (rac and non-rac) yet and would you
say it is better or worse that 11.2.0.1+NovPSU??
onedbguru
|
02-17-2011 12:29 PM
John Hurley | 2 | 3 |
| | | The paper discuses the ability of an Agile BI rollout to respond to
changing data analysis and reporting needs, and provide vital insights
into an...
JTP PR
|
02-16-2011 09:51 PM
JTP PR | 0 | 1 |
| | | i have a problem for "before insert or update" trigger.
Currently this trigger records old table X record in dedicated X_HIST
table (same structure...
Frank Bergemann
|
02-16-2011 12:19 PM
joel garry | 5 | 6 |
| | | Looks like OEL 5.6 just became available last month ...
http://oss.oracle.com/el5/docs/RELEASE-NOTES-U6-en.html
John Hurley
|
02-16-2011 09:25 AM
John Hurley | 3 | 4 |
 | | I invested quite some time in learning the thing, as it seemed very
similar to Oracle. Unfortunately, when it came down to the pilot project,
the...
Mladen Gogala
|
02-15-2011 03:21 PM
Mladen Gogala | 65 | 66 |
| | | Hi all, I have recently installed Oracle on OSX Snow leapard. (10.6.6)
and can not get netmgr running for the life of me. I know that there
was...
Aaron Spiteri
|
02-15-2011 07:17 AM
Aaron Spiteri | 0 | 1 |
| | | Hello out there,
I tried to configure alerts for full tablespaces using
dbms_server_alert.set_threshold. Since we do not have licensed
diagnostics...
Lothar Armbrüster
|
02-12-2011 02:10 PM
onedbguru | 6 | 7 |
| | | I've only just come across this possible SQL bug and was wondering why
this SQL returns a result? I got it through an email and had to change
it to...
DG problem
|
02-11-2011 07:46 PM
Noons | 16 | 17 |
| | | oracle 10.2.0.4 enterprise windows 2003 service pack 2
1) Code we use is driven by concept of list of stale objects at
table level
eg...
dba cjb
|
02-10-2011 08:22 PM
onedbguru | 2 | 3 |
| | | Hi
I figured that you need people like me to ask questions in cdos to keep
it going ;)
I am trying to help a colleague work out why something...
Jeremy
|
02-10-2011 10:21 AM
Jeremy | 3 | 4 |
| | | On Wed, 09 Feb 2011 09:54:09 -0800, ddf wrote:
David, V$SORT_USAGE and V_$SORT_USAGE are synonyms.
QL> select table_owner,table_name from...
dba cjb
|
02-09-2011 01:49 PM
Mladen Gogala | 7 | 8 |
| | | ( Sorry a repeat of blog posting ... )
I get grumpy when I see negative serial#'s in v
$session_connect_info ... this is almost enough to make a...
John Hurley
|
02-08-2011 02:41 PM
John Hurley | 4 | 5 |
| | | Hi
This is on 10gR2 / 11gR2
We have a simple "hello world" type java proc in the database which we
can access via a pl/sql wrapper - works...
Jeremy
|
02-07-2011 05:30 PM
Thomas Olszewicki | 5 | 6 |
| | | This paper has defined Social and Collaborative BI as the merging of
BI with social networking and Web 2.0 technologies.
Direct Link (No Email...
JTP PR
|
02-06-2011 06:16 PM
JTP PR | 0 | 1 |
| | | Have a load of this:
http://it.toolbox.com/blogs/database-soup/why-postgresql-doesnt-have-
query-hints-44121?rss=1
This is just phenomenal! The...
Mladen Gogala
|
02-05-2011 07:15 AM
Noons | 1 | 2 |
| | | Dear group,
We are moving our Oracle database on redhat 4 10.2.0.4 to redhat 5 and
upgrade it to 10.2.0.5
so, on server A(redhat 4), i took a hot...
charles
|
02-04-2011 11:12 PM
bdbafh | 6 | 7 |
| | | Hi,
The following code will stop working if I remove the (xmlns=""). As I don't
control the web-service that generates the XML (and omits the null...
Richard Maher
|
02-04-2011 05:27 PM
Richard Maher | 5 | 6 |
| | | http://www.oracleobserver.com/?q=node/28 seems to have an unnecessary
use of dual, or am I missing something?
It seems to work fine for me without...
joel garry
|
01-31-2011 08:35 PM
John Hurley | 15 | 16 |
| | | any 1 need geniun adsense account or trick at very very nice rate.
contact me at this number , 0306-8486359
my email is, ali_awan02 (AT) yahoo (DOT)...
ali awan
|
01-29-2011 05:49 AM
ali awan | 0 | 1 |
| | | Two magnets will show you more than a thousand books.
(Click link below.)
http://www.amperefitz.com/two.magnets.htm
A letter to my old friend...
fitz
|
01-28-2011 04:57 PM
fitz | 0 | 1 |
| | | Per the subject line, this drives me bonkers. I have a particular
error message for which I am searching a solution. All I end up with
are hits for...
Steve Howard
|
01-24-2011 05:06 PM
jimmyb | 9 | 10 |
| | | I was looking around because of some performance problems with Direct NFS, but it seems nobody
has problems with Direct NFS.
Or is nobody using...
Gerard H. Pille
|
01-22-2011 06:51 PM
Noons | 24 | 25 |
| | | Hi,
i wonder why this doesn't work:
--------------------- snip ----------------------------------------
set serveroutput on
drop table tabx;
/
Frank Bergemann
|
01-21-2011 07:43 PM
Tim X | 6 | 7 |
| | | Dear Group,
I have been working with Oracle without success.
On my box, when i installed 10g, oracle cannot find the ASM disk with
the default path...
charles
|
01-21-2011 12:26 PM
ppineda76 | 4 | 5 |
| | | We keep running into suboptimal query plans with 11g and then we run into
slow queries and once we collect stats, things get better again. How can...
RF
|
01-19-2011 09:55 AM
Mark D Powell | 6 | 7 |
| | | On Jan 18, 1:41*am, Mladen Gogala <gogala.mla... (AT) gmail (DOT) com> wrote:
LOL! Join the club!
Mladen Gogala
|
01-18-2011 11:48 AM
joel garry | 4 | 5 |
| | | I want to build an oracle function, in a 10g Unicode database, that
accepts a varchar, of any length, and returns a translation. It will
translate...
oldyork90
|
01-17-2011 05:11 PM
onedbguru | 5 | 6 |
| | | Hi,
I have some Mviews for query rewrite
it takes 15-20 minutes to create them
The refresh takes more than 5 hours ...
why ?
What can I do to speed...
bob123
|
01-16-2011 05:33 PM
JohnEllis | 11 | 12 |
| | | With rule-based it was quite easy: you made sure an index on that column was used and the
results returned in the desired order, immediately.
But if...
Frank Bergemann
|
01-14-2011 02:59 AM
Gerard H. Pille | 4 | 5 |
| | | Dear group,
We are using Oracle 10g on linux RAC with 4 nodes. We have a small
table, no more than 300 rows, but most people will...
charles
|
01-13-2011 05:14 AM
Jonathan Lewis | 5 | 6 |
| | | I have a SR priority 2, ORA-07445. SR Number is 3-2695873331. They
haven't responded in five days. Look at this:
Update from Customer 10-Jan-2011...
Mladen Gogala
|
01-11-2011 10:29 PM
Mladen Gogala | 6 | 7 |
| | | I started the sqlplus through :
http://homer:5560/isqlplus/
but did not opened .
I tried :
oracle @ Homer /export/home/oracle/database>lsnrctl...
happy
|
01-10-2011 12:10 PM
joel garry | 5 | 6 |
| | | malargeetha20119159686702 (AT) gmail (DOT) com
geethu
|
01-10-2011 08:52 AM
geethu | 0 | 1 |
| | | This is happening at a 2 node windows 2003 rac with 96G ram (free ram
about 70G)
Release of grid infrastructure is 11.2
Database 10.2.0.5.
When too...
HansP
|
01-06-2011 07:40 PM
John Hurley | 5 | 6 |
| | | If it is to double your income next year then explore working on Part
Time, Freelance, Virtual ERP Assignments,Work in Surplus Time and Earn
upto...
ERP Expert
|
01-03-2011 07:04 PM
John Hurley | 2 | 3 |
| | | Hi,
Some one could tel me ?
Sometimes a user account is locked and I do not know why?
Can someone tell me how to log the lock?
thank's
eliot06
|
12-31-2010 11:48 AM
joel garry | 3 | 4 |
| | | I have a query that returns results like this:
Month Agent Cases Worked
---------------- ----------- -----------------------
Sept ...
master44
|
12-30-2010 01:57 PM
Mark D Powell | 5 | 6 |
| | | Joel:
# Now even though management is entirely unwilling to give Oracle any
more money than they have to, my immediate management does...
valigula
|
12-30-2010 01:06 PM
Mladen Gogala | 8 | 9 |
