 | | | Oracle List | | Hi
you might want to look at a paper i found a link to called "Undocumented
Oracle - what they didn 't teach you ate Oracle " - there is a link on my
site http //www.petefinnigan.com/other.htm - iHi
I also unset the PERL5LIB variable and didn 't encounter any probs with
ActiveState Perl 5.8 and Cygwin Perl 5.8.
I don 't know wether the Perl 5.6 that comes with Oracle still works but
w
I haven 't tested this idea but it might work.
Identify the partitions that are in the lost datafiles.
Create empty tables of the same structure in
some on-line files.
For Hi list
Maybe I 'm blind but I couldn 't find any information on the size limit of a single row. Does anybody know to what maximum number of bytes a row can grow in length? Does the usage of "inlineThere is a tables clause for the export utility but that would require
that you list all the tables you do want to export which may not be
ideal.
You could move the table in question to a speci > It 's a test please ignore it as I have sent 3 mails I couldn 't receive
> them but I am able to receive other mails oracle-l.
And if you don 't see it what do you do then?
Send another?
Th
Way back in the dim and distant past of 7.3
partition views you had to write "front-end code "
that knew which table the insert should go to.
That 's probably why there is no information on
inserIf your databases are 9i+ you could just create an external table
to the alert.log file and just view the errors with a select statement.
See http //www.dbazine.com/still1.shtml for an example.
I 'd forgotten I 'd written that note - and
such a long time ago too.
Does anyone have any idea of how many
people are using cpu_costing ? Could we
take a quick poll ? My impression is that
tOne of our DBAs just took a performance class from Kevin Loney. He
reviewed
one of her Perfstat reports and suggested we re-write the query below.
Gotta say I was suprised when I saw trace.
----
-----Original Message-----
From oracle-l-bounce@(protected) on behalf of Dennis Williams
Sent Thu 9/22/2005 8 31 PM
To Paula_Stankus@(protected)
Cc oracle-l@(protected)
Subject Re helSeveral months ago I posted a question about stored_outlines not working in my database (8.1.7.4/HP-UX). After convincing oracle support I was not crazy they came across a bug (3008000). I just a
When the budget comes in can I put in a bid for it ?
You get a really heavy manual to take home to
prove that the money was well spent.
Regards
Jonathan Lewis
http //www.jlcomp.demon.co.update table
set new_year_column substr(old_column 1 4)
new_month_column substr(old_column 6 2)
-- check your cloumn values if correct
commit
Guang
-----Original Message---There probably is a bug with SQL*Loader and direct load
but after a direct load indexes usually are in unusable state.
That is to be expected and is not a part of the bug description.
The situati
It 's released (almost) immediately after it has been
taken but the request need not be granted immediately.
The request is Share (4) or Sub Share Exclusive (5)
so it has to wait for all curreI use symbolic links for a 9.2.0.3 and .4 database and it works fine. You
sure you have the links set up correctly? Do they look like this
mkdir -p /dba/U1009/ldwq
cd /dba/U1009/ldwq
mkdir -p
A similar question came up on the newsgroup about
3 weeks ago under the title
Temporary LOBs in Oracle not freed up
The last comment from on it from the originator was
< <quote > >
Does it work if executed by the owner of the package?
Igor Neyman OCP DBA
ineyman@(protected)
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)Can you clarify your assumptions in the statement that "there isn 't much
difference in hardware requirements " particularly regarding RAM? Are
you assuming that the RAM allocated to the SGA 's for eNice people of the EMC corporation will gladly help you out. As we the DBA folks
like to say disks are cheap. The last increase in the storage capacity that my
company bought in February didn 't cJaco
Here is what I believe.
1. Overall there isn 't much difference in hardware requirements whether all
workload goes through a single instance or multiple instances. I don 't think
you will beHi Guys
In a test I 've been looking at some log files being applied to the
standby database. We have a two node cluster shipping logs to a single
node (physical) standby database.
Below I 've Any chance you can post the lines from the "raw " trace file surrounding that
EXEC line? You 'd want to post any lines after the PARSE and prior to the
first FETCH line as well. I 'm guessing that thFolks
What could be the Cause for HIGH Value of elapsed time 3.27 in the
following SELECT Queries?
NOTE - It is doing a UNIQUE Index Scan
Will provide any info required
Thanks
*****Dennis
It is very interesting to hear that you are tending to go the opposite
direction based on your experience.
The benefits we are hoping the achieve is easier database management and
less----- Original Message -----
From "Skursk? Michal " <Michal.Skursky@(protected) >
> I have an application in which I cannot change the code. There is a > search function in the application on char or varcDick
Thanks for your input.
We are also using Peoplesoft and I isn 't it true that because Peoplesoft is
using 1 user (SYSADM in our case) it is an advantage for my problem.
Now I can use ORM teI am running tru64 I have symbolic links for databases plus in some
cases for log files I am
using context-dependent symbolic link with no problems.
This was with 9.2.0.2/9.2.0.4.
Darren
We have a client that uses Oracle 9i. We are on 8.1.7. We need to exchange
eligibility information and transaction information between our two
companies. They are suggesting creating a user and a ta |
|
|
