 | | | Oracle List | | Ana you have been using db links all the time but when you are
running LDAP or Oracle*Names and your databases have GLOBAL_NAMES
set to true. then you have db link created for each service name
We have the 9.2.0.4 agent running on three AIX 5.2 R6000 boxes. I start
them logged on as Oracle. Oracle does not have root access.
Ruth
-----Original Message-----
From oracle-l-bounce@On 02/11/2004 05 19 38 PM Juan Cachito Reyes Pacheco wrote
> Is Tom Kyte you have an expert in Oracle that does the work for you
> free.
> Is a secret your boss never will get know. And will Delphi??? You can get Spreadsheet WriteExcel from CPAN and do
something like this
#!/usr/bin/perl -w
use strict
use Spreadsheet WriteExcel
# Create a new Excel workbook
my $worIs system busy doing something else?
Is there a chance that system tablespace was analyzed?
Igor Neyman OCP DBA
ineyman@(protected)
-----Original Message-----
From oracle-l-bounce@(protected)On 02/11/2004 03 39 45 PM Luis deUrioste wrote
> Hi Listers
>
> I have a requirement to submit some reports via e-mail in excel
> format > can somebody help me?
>
> Thanks
>
> Luis
BOSSOn 02/11/2004 03 24 09 PM Jacques Kilchoer wrote
>
> For those of you running Linux in production - do you stick with an > Oracle certified release?
Yes. No supported release > no support. Rafiq
I 'm assuming that you mean you want to export/import a schema from
Solaris to Linux? If so just do it. Export/Import will take care of
platform incompatibilities. When you send the exportThe syntax you have below will cause an error in Oracle.
Oracle version of your statement would be
update account
set (account.expire_dt
account.curr_eff_dt
account.acct_end_dt) (selecOn 02/11/2004 02 38 26 PM M Rafiq wrote
> Hi
>
> I am asked to create a 32bit database on Redhat Linux(2.1) and import
> a
> 64bit database(Solaris) in it.
So what are you doing here?
>
Did anyone manage to link tora against 10g? How about DBD Oracle and
DDL Oracle? PHP? Any success/failure to report here? Any initial
results to report about native PL/SQL compilation? I assume thHi Listers
Posted with Jared?s permission of course..!!
My company (www.nmhc.com) is looking for a Senior DBA
to help me out in Port Washington NY. Relocation
expenses are non-existent (I knowWith lots of cache!
-----Original Message-----
From Sakthi Raj [mailto rajan_sakthi@(protected)]
Sent Wednesday February 11 2004 1 03 PM
To oracle-l@(protected)
Subject Re EMC DMX & DW
Your are probably hitting a Windows port-specific SQL*Plus bug. It 's quite annoying and apparently not fixed until 10g.
We 've used dbms_utility.get_time (sp?) as a replacement.
See bugs 2487103 Sony Online Entertainment? Isn 't that the company which employs
certain divinities? You better start studying hard...
On 02/11/2004 10 18 29 AM "Jesse Rich " wrote
> Bummer! Maybe I can get thOn 02/11/2004 09 51 10 AM jtesta@(protected) wrote
> bah 10G wont connect to 8.1.7.2 (yea i know its not terminal release
> but
> not much i can make the client do).
>
> ora-3134.
>
> i 'm donI have the only process running on the server. I am using an undo tablespace with 15 GBs of undo. I have undo retention set to 20000(I just upped it due to the error) and I get the following error. ThSean
I 'm running the same using 8.1.7. Because the expectations of OFS are so
basic your tests are also basic.
Try the obvious
1). Simply shut the database down manually and make sure tIt is 64 bit OS.
Try "-b " option.
The -b option prints the number of bits in the address space of the
corresponding native applications environment
% echo "Welcome to "`isainfo -b` "-bit SolOn 02/11/2004 11 27 29 AM Niall Litchfield wrote
>
> growing intermittently and unpredictably (I liked your K/M confusion
> example (I *think* we can have G from 9.2 as well) AND other stuff
>
On 02/11/2004 10 02 37 PM Jan Pruner wrote
> Sqlplus is a console app so have no GUI.
You mean that I cannot just click 'n 'go? But Microsoft has
so many gooey tools!
--
Mladen Gogala
O
You haven 't given a time-period for the snapshot
so we don 't have a clue about whether the problem
is causing real hardship.
However your comment about 'executions are high '
matches the statJKean
I 'm really glad that you got an answer to your question. I would like to
gently suggest that you make it a priority to become familiar with Oracle 's
concepts. This way you will avoid askinDear All
Can someone help me . I have this application making a
connection to oracle database.
Is there are way i can find out how many connection is
connection to the database by this appliHi Jeff
You can use restore until time to_date( < > fmt) to restore a previous backup and you have to do a incomplete recovery (recover until scn or recover until time) and open the auxiliary instaHi All
I 'm still sort of new to oracle 9iRAC and are trying to find out what is
important to monitor in a RAC environment to keep the system up and running
and detect problems early on. DoesThe 10g installer is so much more performant than 9i wow!
I did a complete install in less than 15 minutes! In 9i it was several minutes just to paint one screen!
Try using a different X server.
Cygwin has worked for me in the past.
Or get a linux box to run it from.
Ask your OPS folks real nice and they might give you
a PC to run linux on.
Jared
Hi I can 't get a substr from a blob I tried substrb too but it doesn 't works
FUNCTION Comparar( bLob12 BLOB bLob22 BLOB ) RETURN VARCHAR2 IS
nCantidad INTEGER 32767
nRetval INTEGER
cOn 02/10/2004 04 17 39 PM "Freeman Donald " wrote
> SET timing ON
>
> ALTER SYSTEM FLUSH SHARED_POOL
Flushing is harmful.
>
> ALTER TABLE PADOHSNAP.HRA_OBS_MAP_DETAIL PARALLEL 1
> SELEC |
|
|
