| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hi spent 12 hours trying to sort this.
Any suggestions??
My hostname is WINDOWS-READ
Used Oracle Net Config Assistant to create Oracle Internet...
Clive_S
|
Yesterday 08:54 PM
John Hurley  | 1 | 2 |
| | | Hello there,
Is there any free Oracle 10g database that will enable me to create
multiple databases, for testing purposes?
I tried 10g and it only...
Tester
|
Yesterday 07:59 AM
Shakespeare | 9 | 10 |
| | | On Mar 11, 8:21*am, gazzag <gar... (AT) jamms (DOT) org> wrote:
Well, finally came up with this beast. It works, so, I'll go with it:
SELECT...
The Magnet
|
Yesterday 06:47 AM
Randolf Geist | 11 | 12 |
| | | I have been doing SQL query tuning for a while and in most cases this
is relatively straightforward excercise. For example: if a query
selects only a...
vsevolod afanassiev
|
Yesterday 04:55 AM
Shakespeare | 11 | 12 |
| | | So when my developers need to make a change to a procedure, instead of
just recompiling the procedure they want to create a new procedure
named like...
jeffchirco@gmail.com
|
03-12-2010 08:15 PM
Galen Boyer | 14 | 15 |
| | | job), '</x>'), '<x>', ' '), 2) job_list
3 FROM emp
4 GROUP BY deptno
5 ORDER BY deptno
6/
DEPTNO JOB_LIST
------...
webtourist
|
03-12-2010 06:42 PM
John Hurley | 2 | 7 |
 | | Hi,
I connected to an Oracle 10.2 via Enterprise Manager (EM) as sysdba.
The checkbox to enable/disable Archivelog-Mode is disabled (grayed...
Chris Seidel
|
03-12-2010 03:03 AM
Shakespeare | 31 | 35 |
| | | Hi All,
I note that using direct I/O (by setting the forcedirectio while
mounting the database file systems) and bypassing the file system
cache may...
Bruce
|
03-11-2010 11:49 AM
joel garry | 1 | 4 |
| | | Hi,
I am currently running two Oracle 10G instances from a single Solaris
M4000 server. Every few days one of the instances crashes with...
Johne_uk
|
03-11-2010 06:28 AM
Alberto Frosi | 14 | 19 |
| | | Got this from MOS, after submitting a SR:
Dear My Oracle Support Customer
Service Request #3-1506509011 does not have Configuration Id, it...
Noons
|
03-10-2010 03:36 AM
Frank van Bortel | 37 | 57 |
| | | Hi all,
Will SQL Loader be able to handle this or will I need to create and
XML DB?
Cheers,
TB3101
trub3101
|
03-08-2010 03:53 PM
John Hurley | 3 | 10 |
| | | Hi,
Just for general understanding, I have a question, related to how the
rowid to index block lookup is done.
This question was spawned by a 10046...
ErikYkema
|
03-06-2010 04:31 PM
Robert Klemme | 5 | 9 |
| | | Hi all
We have a management programme, which uses Oracle DB.
We (I) also make some intranet stuff etc for this system, which uses
the same DB.
Now...
jodleren
|
03-06-2010 12:48 PM
Mladen Gogala | 18 | 25 |
| | | I have some old SQL scripts that use PCTFREE and PCTUSED.
As now we have 10g, should I modify the scripts using ASSM instead of
PCTFREE
and...
moongeegee
|
03-05-2010 02:11 PM
joel garry | 8 | 9 |
| | | Group,
I've installed Grid Infrastructure 11.2
However, there are no start/stop scripts in /etc/init.d to start crs.
Right now we are...
NetComrade
|
03-05-2010 11:56 AM
NetComrade | 0 | 6 |
| | | Consider a table and a query referring to only a subset of the columns
in that table. How early in the query evaluation is the projection
carried...
jbdhl
|
03-05-2010 09:19 AM
John Hurley | 10 | 21 |
| | | Good morning people. I need quiet an odd help in here. Let me see if I
can explain it.
I have an SELECT WHERE IN (<list of ids>).
Let us say that I...
Pedro
|
03-04-2010 01:50 PM
jefftyzzer | 4 | 10 |
| | | I saw some Oracle developers built sql scripts and they add "use tlm;"
at the first line to the scripts.
Does anyone know what it meant ?
Thanks
moongeegee
|
03-04-2010 09:40 AM
Mark D Powell | 1 | 6 |
| | | Hi,
We're running Oracle 10g R2. I'm restoring a copy of the database
onto a different server. Our retention period is 21 days, with...
The Magnet
|
03-03-2010 09:50 PM
Hemant K Chitale | 4 | 12 |
| | | I have the following table
Student:marks
Steve:90
Sam:85
Sue:95
Mark:75
Steve:100
Mark:81
Sue:92
cricketunes@yahoo.com
|
03-03-2010 03:46 PM
ddf | 4 | 13 |
| | | On Tue, 2 Mar 2010 21:46:51 +0100, "bob123" <bob123 (AT) gmail (DOT) com> wrote:
Apparently the table has heavy row chaining, which means 1 row is...
Sybrand Bakker
|
03-03-2010 06:09 AM
Randolf Geist | 2 | 10 |
| | | Hi All,
I am a bit puzzle between Result Cache and Buffer Cache.
As per documentation, result cache keeps the data of query in it and
it is part of...
aman.oracle.dba
|
03-02-2010 11:00 AM
Hemant K Chitale | 3 | 16 |
| | | On Feb 26, 2:47*pm, Mladen Gogala <gogala.mla... (AT) gmail (DOT) com> wrote:
snip
Your original rant did not have any details on what exact...
John Hurley
|
03-01-2010 05:47 PM
John Hurley | 15 | 30 |
| | | SQL*Plus: Release 11.2.0.1.0 Production on Fri Feb 26 17:51:24 2010
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle...
lfree
|
03-01-2010 04:11 AM
lfree | 3 | 16 |
| | | Hi,
we have a Fk pointing to a parent table/column - and now sadly enough
that primary key value will change.
What would be a smart way to implement...
eh
|
02-28-2010 08:57 PM
joel garry | 9 | 27 |
| | | Top Certifications in all Fields - A Complete Guide
RedHat Linux:...
IT eBooks
|
02-28-2010 01:11 AM
IT eBooks | 0 | 11 |
| | | How can I extend the timeout for the SQLPLUS sql commands entry ?
happy
|
02-27-2010 07:54 PM
Mark D Powell | 2 | 11 |
| | | I'm trying to write a stored procedure which will compare two tables
dynamically and will display the difference. The input parameter are
two table...
Sudhir
|
02-27-2010 10:04 AM
Sudhir | 7 | 28 |
| | | hi all i have done oracle 10g database cource but i just want
to know what is the difference regarding performence,management of a
database in oracle...
Mubashir
|
02-26-2010 01:27 PM
John Hurley | 4 | 29 |
| | | Oracle 10.2.0.3 on solaris, running a select query on a test machine
takes one second, execution
plan shows that index range scan is used. On the...
Guy Peleg
|
02-25-2010 03:48 PM
joel garry | 9 | 28 |
| | | 10.2.0.3 64 bit Standard on SLES 10 two node RAC
Hi All,
Does anyone know if it is possible to reverse engineer the SQL_TEXT
for a given SQL_ID? ...
Steve Howard
|
02-25-2010 12:31 PM
joel garry | 10 | 29 |
| | | On 2月25日, 午前1:57, joel garry <joel-ga... (AT) home (DOT) com> wrote:
Thanks for your answer.
Which way do you suggest to check the db...
Jia Lu
|
02-24-2010 08:28 PM
joel garry | 5 | 24 |
| | | On Feb 19, 9:27*am, mhoys <matthias.h... (AT) gmail (DOT) com> wrote:
snip
Interesting ... thanks. I thought that guy would have been ditched...
John Hurley
|
02-24-2010 05:25 PM
John Hurley | 8 | 24 |
| | | Where are looking for a tool which will show the relationships between
a table and all its related objects such as triggers, views,
procedures,...
Mick
|
02-24-2010 03:21 AM
Shakespeare | 8 | 23 |
| | | Hi,
In a 10g database, I am looking for all ways to list references
to a specific data string in any table of a specific schema, assuming
that the...
if_investor@yahoo.com
|
02-23-2010 02:23 PM
if_investor@yahoo.com | 5 | 23 |
| | | Hello,
What is the directory where oracle asmlib disks are created under
solaris?
On linux, the directory is "/dev/oracleasm/disks".
I need to know...
mannu
|
02-23-2010 11:07 AM
ddf | 2 | 11 |
| | | Has anyone used some of the Oracle FGA? We're needing to enable some
auditing. I'm having trouble getting it to work. Reading all...
The Magnet
|
02-22-2010 10:53 AM
The Magnet | 3 | 13 |
| | |
Mac Morino
|
02-21-2010 12:51 AM
Mac Morino | 0 | 19 |
| | | Hi,
We have queries that have been completing in minutes for months in
11.1.0.7 that suddenly took hours to complete. Since the database
table data...
amy
|
02-20-2010 04:50 AM
Randolf Geist | 11 | 52 |
| | | Hi,
I am running a sqlldr command line on Solaris and the data file that I
need to load WILL not have an extension. On DOS/Windows, that is not
an...
z1hou1
|
02-19-2010 05:59 PM
Eric | 10 | 36 |
| | | On Wed, 17 Feb 2010 20:36:36 -0600, Philip Dye wrote:
This is a very old thread, from the time when Oracle was switching from
the old Metalink to...
Mladen Gogala
|
02-17-2010 10:59 PM
Mladen Gogala | 0 | 24 |
| | | Hi all,
I have this problem: I'm trieng to create a text index with this
command:
create index itemlabelvalueidx on ItemLabel (value) indextype...
Reny
|
02-17-2010 04:27 PM
joel garry | 3 | 25 |
| | | I think I see the method behind the new metalink, or "my oracle support"
for that matter. Make it as frustratingly clunky and user unfriendly...
gs
|
02-17-2010 02:57 PM
Shakespeare | 21 | 57 |
| | | Hi,
I am running a shell script which call a perl script which uses DBI to
connect to a remote (ie another server) which creates schemas ie...
syd_p
|
02-16-2010 07:51 PM
John Hurley | 15 | 45 |
| | | I'm getting this column contents (the column is a varchar2(200)):
'K+CS2(26)/DP'
matched by...
Ken Quirici
|
02-14-2010 05:44 PM
Ken Quirici | 3 | 23 |
| | | .... or at least I would be if I had any.
I am running a copy of 10G XE on a WinXP box.
In a troubleshooting session some time ago, I turned on...
BD
|
02-13-2010 08:42 AM
John Hurley | 8 | 41 |
| | | Applied patch bundle 31 on top of my 10.2.0.4 test instance on Win32 a
couple of weeks ago and just noticed that my bdump started to fill
with large...
Vladimir M. Zakharychev
|
02-12-2010 05:32 AM
Vladimir M. Zakharychev | 1 | 41 |
| | | On Feb 7, 8:13*am, "takv... (AT) gmail (DOT) com" <takv... (AT) gmail (DOT) com> wrote:
snip
This is pretty old stuff buddy...
John Hurley
|
02-11-2010 08:38 PM
joel garry | 3 | 29 |
| | | Hi,
Is anyone good at converting the following sql statement's LIKE
clauses into 1 coherent REGEXP_LIKE? I came up with a couple of
solutions but...
Dave
|
02-11-2010 04:57 AM
Tim X | 6 | 33 |
| | | Hi gurus,
Our ADF application connect via JDBC to Oracle DB and using VPD .
This is done by executing
dbms_session.set_context('vpd_new','loc_code',...
Krist
|
02-10-2010 08:45 AM
Vladimir M. Zakharychev | 1 | 16 |
