 | | | Oracle List | |
To get around the exports with RLS/FGAC we use DIRECT Y while running the
export.
Thanks
Babu
Thanks was a combination of nls_language and nls_territory
Dave
-----Original Message-----
From Ganesh Raja [mailto ganesh.raja@(protected)] 20
Sent 29 September 2004 15 25
To David SharpleI am no expert in either Java or Perl far from it. But then I 'm not a
developer. However I use Perl quite a bit to do file manipulation such as
process trace files. There it is just faster than JTHANKS for your help
The customer decided to wait if this happens again specially the word "not
oficially " made them understand that was not a very serious advice.
Juan Carlos Reyes PachecoThanX friends for immediate response.....
Regards
Srinivas
--
http //www.freelists.org/webpage/oracle-l
Hi Mladen Steve and KG
I 've found a bug 3361118 related to ORA-600 [7999} on metalink but the
second argument differs (bug is for [9] I get [113]). I have asked
Oracle if I can go ahead and appHi friends
I am having the following problem while selecting data trhu the dblink
My oracle version is 9.0.2 and I am creating dblink to the database version 8.1.7 ie KPIT.
CREATE PUBLIC DATGreat ... That Makes sense now !!!!
Thanks a Ton for that ... Need to get your Book ...
On Wed 29 Sep 2004 17 39 09 +0530 K Gopalakrishnan <kaygopal@(protected) > wrote
> P1 is the absolute Hi All
Environment Oracle apps 11.5.8 Oracle 9.2.0.5 HP UX B.11.11
While analyzing the Alert Log I saw the following ORA-600 error
Errors in file /mnt/oraprod/proddb/admin/prod/udump/prod_Content-Type text/plain charset ISO-8859-1 format flowed
Content-Transfer-Encoding quoted-printable
Syed
If the Apps is 11.5.5 or grater and you are using autoconfig you only 20
have to runreddy@(protected)
----- Original Message -----
From "Carel-Jan Engel " <cjpengel.dbalert@(protected) >
To <DWILLIAMS@(protected) >
Cc <oracle-l@(protected) >
Sent Wednesday September 2After upgrading the client to 9.2.0.4 JDBC/OCI client gives problem
when it invokes stores procedure which returns CLOB datatype.
On Wed 29 Sep 2004 12 53 27 +0200 Jeroen van Sluisdam
<jOracle on windows has not had this 1gig? 2gig problem in quite a
while. The info I found on metalink was talking about a problem on
8.0.4 and 8.0.5 concerning 4 gig files problems. This was in notI have a long field in a PL-SQL block and I select it into a field. I know
there is a hard limit of 32k characters. Do I get an exception or truncation
if
the value exceeds that length? --ThanksHello all
I am hoping this topic has been discussed on the list before... Can someone help out or send a script or link on how I can send an e-mail after Oracle completes backup. What I am tryinDQpJIGFtIHJ1bm5pbmcgZGF0YSBmaWxlcyBmcm9tIDIwRyB0byAzMEcgd2l0aCBubyBXaW5kb3dz
IHByb2JsZW1zIChXMkspDQpmb3IgdGhlIGxhc3QgeWVhci4NCg0KSSB3b3VsZCBhZHZpc2Uga2Vl
cGluZyBzbWFsbGVyIGZpbGVzIGZvciBhZG1pbmlzdHJhJuan
I don 't have a paper but I do have several database where my files are
larger the 1G. Works fine. There were problems in the past. But I never
had any problems.
I 'm running on 8.1.7 Hi list
Please my customer received one email asking to resize a datafile
and he said
"According to the email you sent the datafile affected has a size more than
1gb that could be causing the
If I recall correctly hard parse grabs a bunch of latches and the bigger
the shared pool the worse the latch contention can get. Although it seems
counter intuitive I think in this case th Thanks a lot Christian ) for sharing free your work
when you have end it please share it I think every one in the list is
interested
but most of them didn 't read Millsap 's book maybe wHi Juan
>you definitively will hve to buy his product Hotsos profiler (unless
you are
>thinking in do it by your self) to put in practices the trace analysis
he
>suggests.
My advice to sthe mistake is perfectly understandable. reusable components can really speed up development time and ease maintenance. they just didn 't know database architecture. method 4 dynamic sql stored in the Just give it a whirl on a small test table. You know how to trace it.
I predict that the ... alter not null .... will have an IS NULL filter in
updating the column to the default value. Bug it if On Tue 28 Sep 2004 15 10 35 -0400 Juan Carlos Reyes Pacheco
<jreyes@(protected) > wrote
> Thanks Jared and how undo data line looks like please do you have an
> eaxmple if possible.
>
Hi Juan
Sorry just repost it with the correct subject!
>you definitively will hve to buy his product Hotsos profiler (unless 20
>you are thinking in do it by your self) to put in practices theYour subquery is a correlated subquery so it will be executed once for every
distinct combination of values of the correlating columns not just once and
the value used for all rows of the outer tRyan
After reading some of the other replies and knowing how hard it can be to
convince a developer I wonder if perhaps showing them the result of an an
extended SQL trace might help? Set up On Tue 28 Sep 2004 15 37 04 +0000 ryan_gaffuri@(protected)
<ryan_gaffuri@(protected) > wrote
> Object Oriented programming is all about reuse so our java guys made a universal update statement thaOS AIX 5.2
DB Oracle 9.2.0.5
I am getting ready to start upgrading my databases from 8.1.7 to
9.2.0.5.
While getting certification approval from our vendors one of them
noted the following The only hits I can find are on google and teoma. They refer to
network security tools (possibly hacker tools).
This sounds somewhat fishy.
Platform?
OS Version?
Oracle Version?
Jared
|
|
|
