er information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jeff Herrick
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
--
o that you can automate
pushes through Active Server Pages and the like (been there..done
that!).
They're both nice toolsbut they're just _tools_ . You need
to figure out how to best use them before you roll them out.
HTH
Jeff Herrick
On Wed, 7 Jan 2004 [EMAIL PROTECTED] wrote:
>
&
try DBMS_LOCK.SLEEP()
Cheers
Jeff Herrick
On Sat, 29 Nov 2003, Jonathan Gennick wrote:
> I know this is going to sound rather crazy, but I want to
> write an INSERT trigger that imposes an arbitrary delay, say
> a half second, or maybe a full second, on each and every
> inse
etwork.
One problem we did run into was printingthey have an IP printer
set up on the convenion sub-net and they are not able to print
to it while they have the tunnel up (of course). The have to
save the .PDF's, shutdown the VPN client and then print.
Cheers
Jeff Herrick
On Fri, 24
ad of auto-detect as well as
hard-coding these values on the switch port. Ditto for the NT app
servers. "friends don't let friends auto-negotiate" =8-)
But I still see periodic TNS-12203's just less of them
Try doing a level 16 trace from the listner end.
Jeff Herrick
On T
reference these API's
Of course, what is written to the queue is highly dependant on
what is reading it from the other (Big BLue!) end...so you
could be writing data, XML or even SQL to be read and processed
from the other end.
HTH
Jeff Herrick
On Fri, 25 Jul 2003, Rakesh Gupta wrote:
>
t can't find the DLL with the path '/' you gave it...I'm pretty
sure the text just gets passed to the LoadLibrary() API.
Once it locates the DLL you _might_ have the name mangling
issues from my previous note
HTH
Jeff Herrick
--
Please see the official ORACLE-L FAQ
blem you're going to find is that the 'extern "C"' syntax
is only supported in C++, so you will have to convert it to
C++. Alternatively use the 'mangled' name in the Oracle definition
and try that route
The depends.exe utility comes with Visual Studio and can
. the question would be whether or not the
8.1.7 NET8 DLL's are backward compatible with the 7.3.4 DLL's
that they will be running against...my _guess_ is that they would
be ok
Cheers
Jeff Herrick
psIf they are going to switch don't go to OCI or ODBC...get
them to use Or
C:\> HELP
and
C:\> HELP FOR
In there you'll find a note that the context variable should have
'%%' instead of '%' in front of it when running in a bat file.
You were using the bat file syntax from a command linewon't
work. The opposite is also true...a
rid of an error from the alert file
after it has emailed you onceyou haven't said how you do this
on your Unix box...looks like it will keep emailing you the
same error every 30 minutes, but I could be missing something =8-)
HTH
Jeff Herrick
On Fri, 21 Feb 2003, Mitchell wrote:
> Hi
oming
at it from the angle that I was trying to protect the information
from somebody like me =8-)
HTH
Jeff Herrick
On Fri, 21 Feb 2003, Chris Stephens wrote:
>
> I've been asked to find out a way to encrypt credit card numbers and store
> that encrypted string in the dat
Known problem with Alpha/Cisco gear...
Just a shot in the dark...but this solved a lot of Maximo crash
issues for us.
Cheers
Jeff Herrick
On Thu, 6 Feb 2003, DENNIS WILLIAMS wrote:
> I have a developer that wrote a VB program using ADO, connecting to Oracle
> 8.1.6 on a Compaq Tru64 serve
access to shared _process_
memory.
Contrast this to the multi-process architecture that Oracle uses
on Unix. The shared memory stuctures are separate from each
individual _process_ and the processes use semaphores or
latches to serialize access to the external memory segment.
HTH
Jeff
lier architectures can be even more confusing =8-)
HTH
Jeff Herrick
On Fri, 17 Jan 2003, Barbara Baker wrote:
> List:
> I'm touching iAS for the first time ever. I don't
> understand even basic stuff about it.
>
> The install I have includes 9.0.2 and 9.0.3.
create controlfile
from there.
Jeff Herrick
non-OCP DBA
On Thu, 9 Jan 2003, David L Phillips wrote:
> No. It would be like getting amnesia and just using the memories of someone that
>looks like you.
> The data stored in the control files is unique to that database. It contains
>
each DNS from each other
and use host files on the client to resolve each host then
it _might_ work =8-0 but YMMV
Cheers
Jeff Herrick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jeff Herrick
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 ht
Recompile the 'C' module. The calling formats from the 64Bit external
procedure handler don't line up with the 32Bit binary .so file.
At least that's my SWAG at it =8-)
Jeff Herrick
On Wed, 8 Jan 2003, John Dunn wrote:
> We have a .so C library file containing C routine
threaded
connections.
Just guessingI just got back from Christmas in Cuba and
I'm trying to exercise my brain...it hurts =8-0
HTH
Jeff Herrick
On Fri, 27 Dec 2002 [EMAIL PROTECTED] wrote:
> Hi,
>
> Oracle 8.1.6 on NT 4.0
>
> Oracle.exe is running at about 85% CPU ut
right thing by redirecting stdoutstdin was already
pointing to the script file. I would go one more paranoid step
further and redirect stderr too.
Jeff Herrick
On Fri, 6 Dec 2002, Orr, Steve wrote:
> Problem: How to keep a standby database in continuous managed recovery
> without having to
ne(sqlerrm);
end;
/
You can use the rowids in the look-aside table to zap
the bad values later.
HTH
Jeff Herrick
On Thu, 5 Dec 2002, Burton, Laura L. wrote:
> Since we don't have that many 3rd party software packages I did make the
> mistake of asking 'Why??' and received
file handles from the CreateProcess API but I could not get
it working. Anything that tries to use a GUI will also cause
it to crash since there's no Desktop window handle.
Ohand whatever you do, don't pass a command buffer larger than
1K (1024 bytes)...you'll notice the ha
of the user security
identifier (SID) if you're moving to a new server. As a
minimum I would think that you would have to open each
task in the tool and re-authenticate.
HTH
Jeff Herrick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jeff Herrick
INET: [EMAIL PRO
ystem then I'm not sure this would be an issue
butI would switch it temporarily to a user account and then
back to LocalSystem to regenerate the security identifier.
Also...check the NTFS permissions on the D: drive for who
has write access.
HTH
Jeff Herrick
On Thu, 5 Dec 2002, Joan Hsieh wr
Install the JVM...see MetaLink Note:156477.1
Jeff Herrick
On Wed, 4 Dec 2002, Randy Pace wrote:
>
> I get the following when trying to use the utl_tcp package on 8.1.7
> database.
>
>
> The following error has occurred:
>
> ORA-29540: class oracle/plsql/net/TCPConnect
Maybe the UNION is trying to resolve duplicates that it doesn't
have to??? i.e. requiring a sort
Have you tried UNION ALL
Cheers
Jeff Herrick
On Sat, 30 Nov 2002, Lisa R. Clary wrote:
> I have 3 individual views (average #records=76,000) with the exact same variable
>names an
7;re using HTML mail agents
but I can't see any reason why a couple of example DOS commands
would make it barf. =8-0
BTWI'm using PINE thru a Telnet session to a BSD host for
all my emails. So I know I'm _clean_ :)
Jeff Herrick
On Sat, 30 Nov 2002, Jared Still wrote:
>
cle Parallel Server) environment.
Not to sound 'flip' here but I wouldn't worry about OPS until
you get your mind around how a single instance works :)
OPS is now known as RAC - Real Application Clusters
Cheers
Jeff Herrick
On Sat, 30 Nov 2002, john wrote:
> Oracle
and/or MTS
Cheers
On Fri, 29 Nov 2002, Jared Still wrote:
> On Friday 29 November 2002 08:43, Jeff Herrick wrote:
> > My understanding
> > from the question was that he was wondering whether each
> > user's process in a dedicated-server configuration opened
> > all
might have mis-understood the question.
On Fri, 29 Nov 2002, Jeremiah Wilton wrote:
> On Fri, 29 Nov 2002, Jeff Herrick wrote:
>
> > None...only the oracle background processes (threads in Winblows)
> > access the datafiles/logfiles etc. All other communication is
> > done thr
stdin/stdout/stderr.
I guess the same could be true of processes running under
windows too. So in the limit...you could hit a wall but only
due to the per-process overhead.
Cheers
Jeff Herrick
On Fri, 29 Nov 2002, Grant Allen wrote:
> Saw an interesting post in comp.databases.oracle.server pos
Parameters.Append para
rs.execute
set rs = nothing
set para = nothing
objConn.close
set objConn = nothing
Response.Write("Hello " & fname & "!")
Response.Write("How are you today?")
End If
%>
HTH
o the same
ident and causing problemsbut I haven't heard of that one
in a long time.
HTH
Jeff Herrick
On Wed, 27 Nov 2002, Stephen Lee wrote:
> > -Original Message-
> > Is it possible For 2 Databases to be Brought up on the SAME
> > machine with the SAME O
S.O.L. in that
department. I think the library formats vary between compilers.
Cheers
Jeff Herrick
On Wed, 27 Nov 2002, Denham Eva wrote:
> Hello,
>
> Apologies if this is the wrong list to write to, but some guidelines would
> be nice.
> We have a legacy software which requires
elling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE
t belong to
you)\n",pidno);
exit(0);
}
The above code will check the pid passed as the first command
line argument to the program. Note that you can't signal arbitrary
processes unless you are the superuser or the process is owned by
your userid.
HTH
Jeff Herrick
On Tue, 3 Sep 2002
s too numerous to mention. They usually
ship as header files (.h) library files (.lib) as well as
runtime (.DLL) files. The entry points are documented and you
'roll your own' from there.
HTH
Jeff Herrick
On Wed, 28 Aug 2002, Jamadagni, Rajendra wrote:
> Applicat
nager (Services.exe) which only reads its environment at system
boottime.
Cheers
Jeff Herrick
On Wed, 17 Jul 2002, Bishop Lewis wrote:
> The Scheduler is installed with IE5.5 - definitively worth the install.
>
> As far as executing some lines but not others - it sounds like a environment
> va
ity'
is smaller of you're only moving a couple of files versus all files
(even with the speed of an 'mv' command)
I guess the command would be pointless if you're the only user
of the database and hence the only user being disrupted. =8-0
Jeff Herrick
On Tue, 9 Jul 2002,
Create a dblink to instance B from A and then within your
proc on A do
proc_on_b@B_INSTANCE(parameter1parameter_n);
The schema that you use for the link to B must have execute
access to the procedure on B
HTH
Jeff Herrick
Jeff HErrick & Associates
On Tue, 25 Jun 2002,
/recompile the SQR then why not create the schema
that SQR expects and front the MV tables with synonyms.
Oh...and when did we start caring if the user was confused? =8-) j/k
Cheers
Jeff H.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jeff Herrick
been there done that, got the
T-shirt
HTH...or maybe I didn't understand your requirement =8-)
Jeff Herrick
Jeff Herrick & Associates
On Mon, 10 Jun 2002 [EMAIL PROTECTED] wrote:
> List,
>
> I have an 'opportunity' to make some points with end users, if possible.
om
a book (can't remember which one!) so your mileage
may vary!
Cheers
Jeff Herrick
Jeff Herrick & Associates
On Thu, 21 Feb 2002, sonia pajerowski wrote:
> Hello All,
> I have a non-partitioned table with 20 millions
> records and growing. Every night a pl/sql stored
> procedur
t foo from bar)
2) determine if there is at least one predicate and output 'WHERE'
3) loop thru predicates (from another table or a list box
construct)
4) tack on the 'AND 1=1;' if you did step 3
5) prepare and execute the DML
HTH
Jeff Herrick
Jeff Herrick & Associates
44 matches
Mail list logo
