[Hamid Alavi]
ANYBODY KNOW WHAT'S THE EQUIVALENT OF THIS COMMAND IN UNIX?
host start cmd /c copy /u04/oradata/AMDEV/rbs01.dbf D:\oradata\fred\backup
host cp /u04/oradata/AMDEV/rbs01.dbf /oradata/fred/backup
--
James Manning [EMAIL PROTECTED]
GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7
don't block
readers? I had heard Progress was on that list, but never confirmed.
--
James Manning [EMAIL PROTECTED]
GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James Manning
INET: [EMAIL
numbers (controlling order of execution) for startup and
shutdown respectively. Much much easier, at least IMHO, than doing
symlinks by hand.
James
--
James Manning [EMAIL PROTECTED]
GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4
--
Please see the official ORACLE-L FAQ: http
a
jmm@bp6:/tmp cat b
jmm@bp6:/tmp cat c
jmm@bp6:/tmp perl -e 'shift; print ' a b c
jmm@bp6:/tmp cat b c | perl -e 'shift; print ' a
James
--
James Manning [EMAIL PROTECTED]
GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4
--
Please see
[SARKAR, Samir]
Check Metalink Note : 56016.999
Is there any way to get access to metalink for those of us not fortunate
enough to have an Oracle support contract? (Startup life is fun!)
--
James Manning [EMAIL PROTECTED]
GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB
[Hamid Alavi]
Database shutdown by itseld(don't know why) then I try to started get the
error for datafile.
Anything helpful in the alert log? Like, I/O errors during archiving
so once all online redo logs needed archiving, the instance stopped
accepting transactions? Just a guess
--
James
') 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-L FAQ: http://www.orafaq.com
--
Author: James Howerton
INET
that would be
more helpful, I still have the raw trace around and would be happy to
re-run it.
Thanks!
--
James Manning [EMAIL PROTECTED]
GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James Manning
.
I'd give the probability rating around 1% at best :)
--
James Manning [EMAIL PROTECTED]
GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James Manning
INET: [EMAIL PROTECTED]
Fat City Network
Hi DBAs,
I want to find out what Oracle patch installed.
Someone just installed Oracle817 binary on our server but no 817
instance setup yet, so can't query v$version.
Thanks
James
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
Is there any Oracle file I can use Unix command strings to search for
version/patch info? I don't have x-window session.
James
-Original Message-
From: Magaliff, Bill [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, February 12, 2002 3:02 PM
To: Multiple recipients of list ORACLE-L
an insert trigger on the table that
sets the PK field to a seq.nextval?
Thanks for your help, Bjørn!
James
--
James Manning [EMAIL PROTECTED]
GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James
(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-L FAQ: http://www.orafaq.com
--
Author: James McCann
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX
the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James McCann
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
. But then, why isn't tkprof more clear on soft
vs. hard parses? :( In any case, it looks like it's not the problem
I thought it was.
--
James Manning [EMAIL PROTECTED]
GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
count (total) 69494630
parse time cpu 1082154
parse time elapsed 1420764
That looks *much* better to me!
James
--
James Manning [EMAIL PROTECTED]
GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4
--
Please see the official ORACLE-L FAQ: http
of transferring large files, I'm all about using rsync
whenever possible simply because you can just keep re-running the same
command until it finally transfers. rsync's site has builds for most
*nix's and google on rsync windows will lead to the various windows
builds that are out there.
HTH,
James
://www.orafaq.com
--
Author: James Howerton
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from
:)
Thanks!
James
--
James Manning [EMAIL PROTECTED]
GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James Manning
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538
want to maintain several separate LDAP's unless there is no other
way. Re-linking Apache with mod_auth_ldap is not supported???
2. Is there a 9iAS listserv similar to this list?
TIA
...JIM...
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James Howerton
INET: [EMAIL
it work it out just between the 2 snaps you
tell it to? i.e. the delta.
Cheers,
Jim
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James McCann
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
Thanks John,
that's what I thought, but I just wasn't sure if it applied for the ratio's
as well,
Jim
-Original Message-
Sent: 31 January 2002 12:55
To: Multiple recipients of list ORACLE-L
HI James,
This will tell you these percentages during the time you are reporting on.
John
see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James McCann
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
of list ORACLE-L
James McCann wrote:
Speaking of default accounts with default passwords, here is my list that
I
check for. Anyone want to compare notes :) i.e. have I missed any?
Thanks,
Jim
perfstat/perfstat
TRACESVR ??? is only used with 7.x Databases
REPADMIN ???
CTXSYS/CTXSYS
[-sysdba || -sysoper]
};
exit $exitval;
}
James McCann [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/31/02 08:42 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: OPS$ / default accounts
Speaking
FAQ: http://www.orafaq.com
--
Author: James Howerton
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE
send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James McCann
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet
...
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James Howerton
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
Sun great sums of money. The Sun web site has more info on HA.
Let me know if you need more info.
Good luck!
Barb
--
From: James McCann[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Thursday, January 17, 2002 5:40 AM
To: Multiple recipients
Oracle to run this crap, but you'll be
paying Sun great sums of money. The Sun web site has more info on HA.
Let me know if you need more info.
Good luck!
Barb
--
From: James McCann[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Thursday, January 17, 2002
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James McCann
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
version (Standard/workgroup can
be used), only runs on NT, and requires MicroSoft Cluster Services (MSCS)
which is included in NT4.0 EE or W2K Advanced Server.
As for Sun Solaris, I know nothing so will be of no help to you there.
James McCann
james@openet
the standby implemented.
There's no additional cost from Oracle to run this crap, but you'll be
paying Sun great sums of money. The Sun web site has more info on HA.
Let me know if you need more info.
Good luck!
Barb
--
From: James McCann[SMTP:[EMAIL PROTECTED]]
Reply
As far
as I know, it only comes with Enterprise or Personal,
Jim
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of
[EMAIL PROTECTED]Sent: 15 January 2002
13:55To: Multiple recipients of list ORACLE-LSubject:
RE: Virtual Private
Bee
-Original Message-
From: James McCann [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 11, 2002 6:25 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Any other OCP discount code ? S36
may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: HAWKINS, JAMES W [IT/1000]
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: HAWKINS, JAMES W [IT/1000]
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
, JAMES W [IT/1000]
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list
).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James McCann
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James McCann
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: HAWKINS, JAMES W [IT/1000]
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access
: http://www.orafaq.com
--
Author: HAWKINS, JAMES W [IT/1000]
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
=%5Eixic');
end;
Peace,
James Reddi
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James
INET: [EMAIL PROTECTED]
Fat City Network
://www.orafaq.com
--
Author: James Damiano
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from
=01e=31f=01g=ds=ADCTy=0z=%5Eixic');
end;
Peace,
James Reddi
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James
INET: [EMAIL
).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James Howerton
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
=31f=01g=ds=ADCTy=0z=%5Eixic');
end;
Peace,
James Reddi
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James
INET: [EMAIL PROTECTED
Thanks Ron,
The SGI install only has $ORACLE_HOME/lib32/ $ORACLE_HOME/lib/ dir's.
...JIM...
[EMAIL PROTECTED] 12/13/01 7:40:17 PM
James,
You need to have the library for the 64 bit of Veritas... on AIX, it is
done
as follows:
ln -s /usr/openwin/netbackup/bin/libobk.a $ORACLE_HOME/lib64
great insights...
Jim Damiano
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James Damiano
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
address where I can read
this paper?
thanks
Gene
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James Damiano
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access
is no help as usual.
TIA
...JIM...
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James Howerton
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
James,
Have you tried Veritas's web site?
It's at http://support.veritas.com/menu_ddProduct_NETBACKUP.htm
Click on advanced search under Knowledge Base in the
middle right part of the page.
Search on the error message that you get. Try all the error numbers
by themselves. You should get
.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-Original Message-
JAMES W [IT/1000]
Sent: Thursday, December 06, 2001 2:26 PM
To: Multiple recipients of list ORACLE-L
Hello all,
I know this has come across many times now, and I thought I had it saved
somewhere - you
the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: HAWKINS, JAMES W [IT/1000]
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
://www.orafaq.com
--
Author: HAWKINS, JAMES W [IT/1000]
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself
://www.orafaq.com
--
Author: HAWKINS, JAMES W [IT/1000]
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself
ergh Blvd. St. Louis, Missouri 63167 Work (314)
694-4417 Cellular (314) 724-9664 Pager (314)
294-9797
[EMAIL PROTECTED]
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Monday, December 03, 2001
2:46 PMTo: '[EMAIL PROTECTED]'; HAWKINS, JAMES W
[IT/1000]Subject
Title: RE: BMC Patrol DBXray / CA Unicenter
Lisa,
We are
now concluding a very lengthy selection process, and it looks like we will go
with BMC Patrol/DB X-Ray. We refuse to do business with CA, and had a very
bad experience with Quest I/Watch. None of these are easy to roll-out
enterprise
Title: rman restore & arclogs
I just
wanted to throw something else out there - it may have already come up
though. We backup the archivelogs first without deleting them, and then
immediately backup another set with the "delete" specified. Obviously,
this is because anything can happen to
the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: HAWKINS, JAMES W [IT/1000]
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
FAQ: http://www.orafaq.com
--
Author: HAWKINS, JAMES W [IT/1000]
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
(like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: HAWKINS, JAMES W [IT/1000]
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
ORACLE-L FAQ: http://www.orafaq.com
--
Author: HAWKINS, JAMES W [IT/1000]
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
obvious.
James
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of K
Gopalakrishnan
Sent: 04 November 2001 14:35
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle Archiving insanely
By any chance HOTBACKUP is turned on?
Best Regards,
K
,
drop the users, then import the same kind of export
I mentioned in #2.
Any thoughts or opinions would be greatly appreciated. Thanks in advance.
Jim Damiano
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James Damiano
INET: [EMAIL PROTECTED
.
James
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
Ramasubramanian, Shankar (Cognizant)
Sent: 30 October 2001 12:46
To: Multiple recipients of list ORACLE-L
Subject: Internal error code problem
Hi friends,
I am running a package in my
what may have caused the situation. I guess I'll have to
wait until it happens again and get the users to wait until I can gather more info
befor I fix it.
...JIM...
[EMAIL PROTECTED] 10/19/01 1:02:35 PM
Hi James,
setting an event at init/session level would basically
dump the error state
ORACLE-L FAQ: http://www.orafaq.com
--
Author: James Howerton
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
. if needed.
Cheers,
James Campbell
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Campbell, James
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access
for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: HAWKINS, JAMES W [IT/1000]
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
events.
HTH,
James Turner
-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, September 11, 2001 8:10 AM
To: Multiple recipients of list ORACLE-L
Hallo,
Is it possible to do ftp commands directly from PL/SQL procedur? Including
logon to the ftp server.?
Give me an example please
figured it out.
The friendly manual is helpfull as usual, IOUG diddn't have anything we could use.
We have data being loaded in a 8.1.6.2.1 database via ODBC from a hub(interface)
engine.
TIA
...JIM...
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James Howerton
INET
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-L FAQ: http://www.orafaq.com
--
Author: HAWKINS, JAMES W [IT/1000]
INET: [EMAIL PROTECTED]
Fat City Network Services
Title: RE: OT: football fan-hood
Lisa,
I, for
one, hold you in the highest esteem and wish you would talk some sense into my
wife. My typical Sunday during Rams home games goes something like
this:
6AM -
Coffee, breakfast, read the Sports section for today's
matchup.
8:30AM
- Meet at my
can't see the issue here. sounds like your wife needs
a hobby.
-Original Message-From: HAWKINS, JAMES W [IT/1000]
[mailto:[EMAIL PROTECTED]]Sent: Thursday, August 30,
2001 11:01 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: OT: football fan-hood
Lisa
, including the assitants, will work fine after
this and will work with RedHat 7.0 and kernel 2.2.16 kernel, as well as the
2.4.0 and 2.4.1-pre11 kernels.
Jim Damiano
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James Damiano
INET: [EMAIL PROTECTED]
Fat City Network
.
St. Louis, Missouri 63167
(314) 694-4417
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, August 30, 2001 12:27 PM
To: Multiple recipients of list ORACLE-L
I think it's that pass out part she's upset with :)
From: HAWKINS, JAMES W [IT/1000] [EMAIL PROTECTED]
Reply-To: [EMAIL
(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-L FAQ: http://www.orafaq.com
--
Author: HAWKINS, JAMES W [IT/1000]
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538
). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: HAWKINS, JAMES W [IT/1000]
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
Jared,
I'm in for $12.
Jim Howerton
Senior Oracle DBA
University of Alabama at Birmingham
Health System Information Services
e: [EMAIL PROTECTED]
v: 205-934-9111
f: 205-934-0632
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James Howerton
INET: [EMAIL
a DBA, you have a lot
of leeway to change things around on the back end w/o breaking the app.
One drawback to the approach is that it requires more up-front planning on the
app developers to identify the database calls.
James
Turner
DBA
Unplugged
Games
-Original Message-From: [EMAIL
Can you change from a sql statement to an anonymous
pl/sql block? You can trap for dup val on index or
check for the records existence prior to trying to
insert the new record.
james
--- Tatireddy, Shrinivas (MED, Keane)
[EMAIL PROTECTED] wrote:
Hi lists
i need help in writing a sql query
there is this mismatch - or am I missing something obvious?
Another bit of information, all the datafiles are AUTOEXTENSIBLE.
Thanks very much,
Jim Damiano
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James Damiano
INET: [EMAIL PROTECTED]
Fat City Network Services
for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: HAWKINS, JAMES W [IT/1000]
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access
: http://www.orafaq.com
--
Author: HAWKINS, JAMES W [IT/1000]
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: HAWKINS, JAMES W [IT/1000]
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James Howerton
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet
: HAWKINS, JAMES W [IT/1000]
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing
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-L FAQ: http://www.orafaq.com
--
Author: James Howerton
INET: [EMAIL PROTECTED
that actually makes the connection to the
SQLNET (Net 8) running on the server:
- ODBC itselfor
- ODBC through SQLNET?
Thanks very much in advance!
Jim Damiano
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James Damiano
INET: [EMAIL
://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: james ellis
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
All,
Oracle9i EE show's up as orderable on Metalink this morining for Solaris, OS390,
HPUX.
...JIM...
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James Howerton
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San
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-L FAQ: http://www.orafaq.com
--
Author: James Howerton
INET: [EMAIL PROTECTED]
Fat City
the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James Howerton
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James Xing
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James Xing
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
is to setup thresholdaction, it will be fired up
automically when the space reach certain percentage defined.
James
And thus you discover the inane mechanism that SQL Server
inherited from Sybase, by which both try to do concurrency.
Guess what happens when a long running transaction marks
the log
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-L FAQ: http://www.orafaq.com
--
Author: James Xing
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858
.
James
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Bowes, ChrisSent:
Wednesday, May 23, 2001 8:28 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: Maximo
ON all the maximo installations I have done, the biggest
problems have been
Walt @#$$^^@!
Disney. The REAL Pooh is much wiser than that cheap greetings-card stuff!
Regards,
James Campbell
(Oracle DBA when all the real ones have left; Duhveloper; Pooh fan of 45
years standing)
It's Friday in Australia...
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
101 - 200 of 222 matches
Mail list logo