| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hi all,
I'm trying to investigate a table drop using LogMiner.
I can locate the needed SCN and can see the 'DROP' command in V
$LOGMNR_CONTENTS...
andreik
|
03-18-2010 09:02 AM
andreik  | 11 | 190 |
 | | Hi all
I'll use Oracle 10g R2 on Linux with RAC, from the old system we used
oracle 7 on Miracle Linux.
With 10g R2 I want to know if Red hat...
Jia Lu
|
03-17-2010 06:30 PM
John Hurley | 6 | 121 |
| | | Hi group,
I was trying to figure out the internal representation of the clob
type column to see if it is UTF8 encoded, but couldn't find...
Rui Zhang
|
03-16-2010 01:55 PM
Michel Cadot | 4 | 263 |
| | | Hi,
I have the following query (9.2.0.6)
with * => <1s
with count(*) => 7:52 min
bob123
|
03-16-2010 02:50 AM
Randolf Geist | 3 | 140 |
| | | 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
|
03-15-2010 12:53 PM
Shakespeare | 3 | 150 |
| | | Hi,
I upgraded a Win2000 (SP4) server from Oracle 9i to 10.2.0.4. (It is a
SAP system, not
supported for Ora11).
The upgrade went well. I used...
if_investor@yahoo.com
|
03-15-2010 12:16 PM
joel garry | 4 | 123 |
| | | Kaspersky Anti-Virus/Internet Security 2010 v.9.0.0.736 Final +
Kaspersky Skin 2010 + Key Kaspersky...
hussam elagmy
|
03-15-2010 01:07 AM
hussam elagmy | 0 | 125 |
| | | 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
|
03-13-2010 06:59 AM
Shakespeare | 9 | 260 |
| | | 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
|
03-13-2010 05:47 AM
Randolf Geist | 11 | 193 |
| | | 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
|
03-13-2010 03:55 AM
Shakespeare | 11 | 219 |
| | | 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 07:15 PM
Galen Boyer | 14 | 237 |
| | | 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 02:03 AM
Shakespeare | 31 | 666 |
| | | 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 10:49 AM
joel garry | 1 | 132 |
| | | 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 05:28 AM
Alberto Frosi | 14 | 393 |
| | | 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 02:36 AM
Frank van Bortel | 37 | 804 |
| | | 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 02:53 PM
John Hurley | 3 | 139 |
| | | 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 03:31 PM
Robert Klemme | 5 | 136 |
| | | 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 11:48 AM
Mladen Gogala | 18 | 235 |
| | | 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 01:11 PM
joel garry | 8 | 126 |
| | | 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 10:56 AM
NetComrade | 0 | 112 |
| | | 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 08:19 AM
John Hurley | 10 | 253 |
| | | 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 12:50 PM
jefftyzzer | 4 | 141 |
| | | 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 08:40 AM
Mark D Powell | 1 | 124 |
| | | 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 08:50 PM
Hemant K Chitale | 4 | 222 |
| | | 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 02:46 PM
ddf | 4 | 185 |
| | | 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 05:09 AM
Randolf Geist | 2 | 118 |
| | | 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 10:00 AM
Hemant K Chitale | 3 | 146 |
| | | 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 04:47 PM
John Hurley | 15 | 297 |
| | | 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 03:11 AM
lfree | 3 | 238 |
| | | 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 07:57 PM
joel garry | 9 | 275 |
| | | Top Certifications in all Fields - A Complete Guide
RedHat Linux:...
IT eBooks
|
02-28-2010 12:11 AM
IT eBooks | 0 | 122 |
| | | How can I extend the timeout for the SQLPLUS sql commands entry ?
happy
|
02-27-2010 06:54 PM
Mark D Powell | 2 | 165 |
| | | 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 09:04 AM
Sudhir | 7 | 245 |
| | | 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 12:27 PM
John Hurley | 4 | 287 |
| | | 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 02:48 PM
joel garry | 9 | 230 |
| | | 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 11:31 AM
joel garry | 10 | 382 |
| | | 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 07:28 PM
joel garry | 5 | 208 |
| | | 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 04:25 PM
John Hurley | 8 | 186 |
| | | 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 02:21 AM
Shakespeare | 8 | 140 |
| | | 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 01:23 PM
if_investor@yahoo.com | 5 | 214 |
| | | 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 10:07 AM
ddf | 2 | 203 |
| | | 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 09:53 AM
The Magnet | 3 | 245 |
| | |
Mac Morino
|
02-20-2010 11:51 PM
Mac Morino | 0 | 170 |
| | | 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 03:50 AM
Randolf Geist | 11 | 351 |
| | | 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 04:59 PM
Eric | 10 | 335 |
| | | 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 09:59 PM
Mladen Gogala | 0 | 203 |
| | | 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 03:27 PM
joel garry | 3 | 238 |
| | | 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 01:57 PM
Shakespeare | 21 | 362 |
| | | 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 06:51 PM
John Hurley | 15 | 379 |
| | | I'm getting this column contents (the column is a varchar2(200)):
'K+CS2(26)/DP'
matched by...
Ken Quirici
|
02-14-2010 04:44 PM
Ken Quirici | 3 | 158 |
