May be I'm a naive idiot (Forrest Gump :-)), but
have somebody asked Oracle to sponzor this community of Oracle users?
Jan Pruner
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jan Pruner
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051
Title: Clarification on External procedure in Oracle 8.1.6
Hi all...
I believe any of u Would be of GREAT help...
I have been trying Calling C functions from pl/sql using Oracle 8i's External Routine. It works. But when I try to call the Pro*C function after precompiling it .. it is
What Monitoring Activities Need to be Carried Out on Large Databases (
Excess of 100 GB ) ?
Any Experiences , best Practices , Documents , Links ?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VIVEK_SHARMA
INET: [EMAIL PROTECTED]
Fat City Network Services--
You can use the Rank () function to rank your rows
based on a simple or complex criteria in a subquery or
an inline view and then extract the requisite set by
using a simple condition on the Rank col. Below is a
simple example just to give you some idea of what is
possible. You may want to take a
As another UK citizen (who would pay from his own pocket) I would prefer an
annual sub since the cost of currency conversion can be steep on small sums.
Simon Fox
Room 205, CRH
01270 533997
-Original Message-
Sent: 29 August 2001 19:17
To: Multiple recipients of list ORACLE-L
Just
Dear all,
Here is the query to do the same:
select outer.* from(select inner.*,ROWNUM as Query_Rownum from
(select * from tablename)inner where Rownum =to) outer where
Outer.Query_Rownum=from
/
Hope this helps!
Regards,
Ranganath
DISCLAIMER: This correspondence is confidential and
Tatireddy, Shrinivas (MED, Keane) wrote:
Hi lists
how to do the folloiwng inserts into a table?
table xyz has col1,col2, col3.
I need to populate the values to col1 from table dummy1 (cola)
col2 table dummy2(colb)
please anyone tell me how to call external procedures(C) from plsql with an
example.
-Original Message-
From: Ramesh_Kota [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 10:20 AM
To: Multiple recipients of list ORACLE-L
Subject: Clarification on External procedure
Surely those of us in the UK can pay electronically (say via Credit Card)??.
I've done this for other things such as DVDs (15$) etc.
Lee
-Original Message-
Sent: 30 August 2001 09:55
To: Multiple recipients of list ORACLE-L
As another UK citizen (who would pay from his own pocket) I
I'm in too
DBAndrey
* 03-9254520
* 053-464562
* mailto:[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, August 29, 2001 10:28 PM
To: Multiple recipients of list ORACLE-L
Hola,
I think a subscription is the best solution. I have learned too much reading
the solutions to the
Lee,
They are considering payments by PayPal - www.paypal.com
This does in fact let you pay by credit card, and look like a nice easy way
of doing it also..
-Original Message-
Lee - lerobe
Sent: Thursday, August 30, 2001 10:57
To: Multiple recipients of list ORACLE-L
Surely those of
Hello,
Excuse me for this
maybe dummy question, I am new at Oracle and coming from Sybase world, I
subscribed to this list 1 week ago. If my question is answered somewhere in
archived place, please feel free to direct me to this place.
I am looking for
Oracle built-in tools to
No, and I don't think we should. Oracle sponsorship would mean they might
want to control contents of the list
IOUGA sponsors user groups - it's a remote possibility that we could get
them to define us as a user group and then give us a grant to cover Bruce's
expenses. But it would take
Title: RE: tab ascii value
This script prints the ascii table
whole.
May be usefull.
Bunyamin
set serveroutput on size 10240
declare
i number;
j number;
k number;
begin
for i in 2..15 loop
for j in 1..16 loop
k:=i*16+j;
dbms_output.put((to_char(k,'000'))||':'||chr(k)||' ');
if k mod 8 =
Jared,
I'm in for $12.
Dias Costa
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dias Costa
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
Do I have an Amen?
Yes !
Orr, Steve wrote:
I like Jeremiah's idea.
All the sermonizing about the value of the list and how we should be
required to put something in the offering basket is just so much
preaching to the choir. :-)
I would gladly pay a subscription fee because I
your query is equivalent to ,
select * from tablename where rownumnum =10;
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 30, 2001 2:55 PM
using sql query - Solved
Dear all,
Here is the query to do the same:
select outer.*
Hi,
We are doing testing of oracle 8i parallelism features
on unix HP 11 .
We have done 2 partitions on the table ib020mb_3
on a field adt_date with the following details
(partition p1 values less than('22-apr-2000')
tablespace CONTRACT,
partition p2 values less
than('01-jUn-2000')tablespace
Just look at the number of OT postings in the last couple of months...
: )
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de
hi,
Ora817 documentation says, that I have to put TNS_ADMIN under each
...\SOFTWARE\ORACLE\HOMEn . And it works very well on a machine with four
OraHomes! But on another machine with only 806-installation I have to put it
under ...\SOFTWARE\ORACLE. Is there any rule behind that? Where do I find
Thanks Tom!RBG
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 29, 2001 4:50 PM
Ruth,
According to Michael:
Tom:
I haven't got a change to test it. I will try it sometime today. However,
page 11-11 of Oracle8i Backup and
Hi all,
Oracle 8.1.6, OS - win NT.
I have an requirement to call an external procedure through Pl/sql.
I adopted all the steps guidelined by oracle, but only i'm stucking with
creating the extproc.dll file
in oracle home.
when i try to run the dos batch file oracle_home\plsql\demo\make.bat,
I don't think they would agree to that as they would point to MetaLink.
Jon Walthour
-Original Message-
Sent: Thursday, August 30, 2001 3:30 AM
To: Multiple recipients of list ORACLE-L
May be I'm a naive idiot (Forrest Gump :-)), but
have somebody asked Oracle to sponzor this
So then the Canadian conversion would be
$20 US . 28 Loonies in Canada!!
You gotta love a currency called the loonie!! I got to spend a lot of time
in Winnipeg and I really liked.
Dave
-Original Message-
Sent: Thursday, August 30, 2001 3:55 AM
To: Multiple recipients of list
Ok for people living in US. How about people willing to contribute but
living overseas?
Regards
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, August 29, 2001 00:29
To: Multiple recipients of list ORACLE-L
Subject: !! *Very* important
Install C++ compiler.
Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 30, 2001 8:30 AM
Hi all,
Oracle 8.1.6, OS - win NT.
I have an requirement to call an
I thought that she was s overwhelmed by the choices available that she decided to
be an outsider and pick a team from snow-bird country so she would be accepted in
Ft.Laud.
After all she does have 3 Florida football teams to choose from. Very confusing and it
can upset your pears,
Title: RE: OT: football fan-hood
BLASPHEMY!
-Original Message-
From: Scott Shafer [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, August 29, 2001 6:35 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: OT: football fan-hood
Lisa's really a Dolphins phan in purple viking drag...
Hi Gang,
I was reading all the comments, and saw the one about 'Corporate'
sponsorship ...
BILL LAW of OraStaff - don't you feel this is a good opportunity .. ? (Don't
you feel a moral obligation?)
Regards
Oweson Flynn
--
A clean
Title: RE: OT: football fan-hood
BLECH! My second favorite team is Tampa (they are half ex-vikings) I dare say they will be better than the Vikings this year.
Charge that $5 to my account. Sorry.
The short story is:
Grew up in MN... my whole family watched the Vikings... my grandfather
Title: RE: DB Monitoring
HI Vivek, off the top of my head:
Number of extents - any reaching huge numbers?
Tablespaces running out of room? Drives on the host filling up?
Any jobs that have been running over 24 hours?
Possible zombie processes?
Top 10 most resource-intensive queries. Can
Title: RE: financial problems with fatcity.com
THAT IS A FANTASTIC IDEA Oweson. If he places one person from this list he can sure afford it.
-Original Message-
From: Oweson Flynn [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 9:22 AM
To: Multiple recipients of list
Same things for a 1G database in my opinion.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275
Fuelspot
73 Princeton
I usually just make sure that all of my tnsnames files and listeners match.
Then using only one of the listenters I am able to connect to all of the
db's.
Sincerely,
Kev
-Original Message-
Sent: Thursday, August 30, 2001 8:08 AM
To: Multiple recipients of list ORACLE-L
hi,
Ora817
Hi,
It would have been helpful to include the whole select statement.
Anyway.: If your where clause is pretty straightforward (where word
='UNIVERSITY' for instance) it may help to index the columns in the where
clause.
Proper indexing and it should run normal. If you have functions in your
ACID
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275
Fuelspot
73 Princeton Street
North, Chelmsford 01863
Title: RE: OT: football fan-hood
Who's
your favorite hockey team? Just curious since you grew up in
snowda.
Kev
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent:
Thursday, August 30, 2001 9:27 AMTo: Multiple recipients of list
Title: Message
Try
inserting into it, you will not be able to insert anything.
Although Oracle allows it, it will not let you put data in it.
"Do not criticize someone until you walked a
mile in their shoes, that way when you criticize them, you are a mile a way and
have their shoes."
Been there, done that. An installation manual comes from Oracle with the
software. Follow it exactly. Do not use an installation manual for a
different platform or a different version of Oracle. Every one of them is
slightly different and just enough different to mess up your installation.
Duplicate your database using RMAN. Then export/import the table that was dropped.
Of course, this means that you need to have an extra 150 Gb of disk space lying around.
-Original Message-
Sent: Monday, August 27, 2001 5:11 PM
To: Multiple recipients of list ORACLE-L
DBAs
Last
flat files data bases are mostly used for molecular biology data storage,
I do not know of any molecular biology data bank that runs undeer a real
data engine, but it has many reasons why, and of course u can import
these flat files and get them in to a real database engine, and OFCOURSE
it
Go to Oracle Technology Network. You'll find it under the documentation
section (http://technet.oracle.com/docs/products/oracle7/doc_index.htm) they
have the following:
Oracle7 Server for Sun SPARC Solaris 2.x, Release 7.3.4
Administrator's Reference for UNIX
Installation Guide
I have used
Yes, Oracle can handle that perfectly fine.
But there is no question file system has higher throughput due to the many
things Oracle has to do to enforce Atomicity, Consistency, Isolation,
Durability.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize
Count me in. While I have time to read the list, I always enjoy it.
Joan Hsieh
DBA-ocp 78
617-627-5032
Andrey Bronfin wrote:
I'm in too
DBAndrey
* 03-9254520
* 053-464562
* mailto:[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, August 29, 2001 10:28 PM
To: Multiple
Dear DBA Gurus,
I am getting the following error while inserting into a schema's parent
table which is being referred by 42 tables of another schema.
ORA-04031: unable to allocate 2196 bytes of shared memory (shared
pool,RA_VOLUME_PLAN_POOL,KQLS heap,KQLS MEM BLOCK);
How do I resolve this? I
I have subscribed to the Auerbach Oracle Internals news letter in the past
at $150 a year, if memory serves.
I would offer that this list is 100 times more valuable to a DBA (even
Duhvelopers).
That said, I would willingly pay any reasonable monthly/yearly fee to
continue the list.
Steven Haas
no, those posts keep us underworked DBAs from killing the duhvelopers who
make us do the same thing over and over and over and who never listen when
we tell them the correct way to design the tables.
:)
From: Boivin, Patrice J [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple
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
Just thought I would mention this interesting little feature. Now I don't
know if I am an idiot or if something went wrong (probably both), but
apparently NT services will not start the instance. I had to manually start
it to get it to go? I guess in a way that's good, move little nt people
How much is that in EUROs,
for the future,
and do we allow for differences in the depressed state that the EURO is in.
I understand in the IRISH republic,
that the Church is worried that when it changes,
their value amount will be less.
-Original Message-
Sent: Wednesday, August
Define ORA- errors that are critical and grep the alert.log and page if
there are errors.
Segments that cannot extend.
Segments near max extents.
Archive log disk space low.
Locks.
Hit rates, system statistics, etc.
From: Koivu, Lisa [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To:
Sorry list,
I sent the following to the list by mistake.
srinivas
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access /
Why is your shared pool so tiny?
-Original Message-
Sent: Thursday, August 30, 2001 10:37 AM
To: Multiple recipients of list ORACLE-L
Dear DBA Gurus,
I am getting the following error while inserting into a schema's parent
table which is being referred by 42 tables of another schema.
Hi all,
Think we've figured this out, with much
help from you guys.
I believe the high percentage of kernel CPU
was due to the system swapping. I believe the root cause of the swapping was a
combination of:
a) an SGA that was too large
b) a sort_area_size that was set too
large (30Mb.)
Here is an external procedure I call from within pl/sql.
This is for unix so I create a .so file and mapped it with the library. In
Windows NT, you would create a .dll and map it the same way in oracle with
the library.
-- * START OF FUNCTION F_CHECK_FAQ
--
Hallo
Can anyone give me an example on how to write a unix script
which schedules the run run of a sqlloader script from unix server into the database.
I mean I could easily get the file tmanually o be imported if i use the ftp command,
but how do i do
if I want that to be scheduled?
Roland
I agree.
Anjan
mohammed bhatti wrote:
my 2 cents. i think it was re-iterated that payment
was not necessary so i don't think folks should feel
guilty if they can't pay. we're throwing out figures
like $10, $20, $50 etc. for us in the US, this is
barely the cost of lunch or dinner, so
Title: RE: !! Keeping the list alive
AMEN!
-Original Message-
From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 10:46 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: !! Keeping the list alive
no, those posts keep us underworked DBAs from
Title: RE: OT: football fan-hood
Jim,
for
the life of me, I 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
Old behavior especially in W2K with Oracle 8.1.6.0 (solved by 8.1.7.0).
Regards,
Hatzistavrou Yannis
-Original Message-
From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 16:56
To: Multiple recipients of list ORACLE-L
Subject: 9i NT
Just
Interesting post, but it highly depends on the duh-velupur as well as the db
eh.
Some developers are very aware of SQL Tuning, some are not.
Some DBA's are great coders, some are not.
But neither are as good as a good developer and a good dba working together.
Do not criticize someone until
Hi, Jerry,
Next time you see top output like shown below, please provide this information:
In SQL*Plus:
select * from v$session_wait where sid = (select sid from v$session where paddr
= (select addr from v$process where spid = 2286));
may need to run it a few times. Post it to the list (or
Beat me to the punch John, however Jims analysis of the day transcends all
of that.
The only bit I disagree with is the going home and sobering up for dinner
before having more beer.
What a waste of those already consumed. Stay out on the town and keep
drinking
Lee (hic !!)
Sounds like your company is looking for a new DBA? :-
Jan Pruner
Dne ?t 30. srpen 2001 17:26 jste napsal(a):
I have to say I resent being called a duhveloper, granted the majority
couldn't tune a banjo let alone tune a piece of SQL, but as a techie (and
we all are), I find this list
we'll not get into the argument that what you play is not football... :o)
What you call soccer is football... your football is more like rugby
just my euro's worth... ;oD
-Original Message-
Sent: 30 August 2001 15:01
To: Multiple recipients of list ORACLE-L
Lisa,
I, for one,
I have to say I resent being called a duhveloper, granted the majority
couldn't tune a banjo let alone tune a piece of SQL, but as a techie (and we
all are), I find this list invaluable for getting advice on a wide range of
topics, not just keeping a DB up and running or tuned...I don't call you
Of course the guilty ones want to avoid that $1000 fine...
: )
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
From: Koivu, Lisa [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 12:22 PM
To: Multiple recipients
I've gone thru the FM for about 4 hours now, to no avail.
I thought oracle uppercased tables and columns that were not enclosed in
double quotes("), but for query rewrite to pick up on a materialized view, the
SQL has to be EXACT(oracle supposedly strips whitespace), but if i spell the
Apologies for the
length of the mail.
This query is
running for a mad amount of time, anyone any ideas.
Code and tkprof out
put shown below.
Huge
TIA
Lee (who must learn
more about such things !!!)
DECLARE CURSOR
TEMP_CDS ISSELECT
ACXIOM_CUSTOMER_KEY,
VERSION_NO,
Hello Folks,
I am looking for some cool script to move all the database objects
across from Oracle 8.1.7 to Latest Sql Server (ver ???)
frequently.
Is there any particular way we can do it to automate this ??
BTW: I want to pledge $20 or even willing to pay yearly subscription and it
Title: AW: Unix-script
Hi Roland,
try this:
1) shell script
#!/usr/bin/ksh
# ora_load.sh
# load data to db using sql loader
. /etc/profile
. $HOME/.profile
cd /home/oracle/load
# set Oracle specific environmental variables here
export NLS_NUMERIC_CHARACTERS=.,
export
Oweson,
One of the most damn sensible things
I have heard in a while.
I agree -- recruiters and others who
make $$ from this list should lead
by example in donating to FATCITY.
Ross
-Original Message-
Sent: Thursday, August 30, 2001 9:22 AM
To: Multiple recipients of list ORACLE-L
2 possible reasons
1-Your hint is not working. Type as
select /*+ parallel(ib020mb_3,2) */ adt_date from
--there must be space between + sign and parallel and * else it is
--treated as a comment
ib020mb_3
where adt_date '01-jun-2000'
2) are your table/indexes analyzed
a) compare explain plan
Count me in!
===
Patrick Housholder
Sr. Staff Engr Sim Fleet.
United Airlines Flight Training Center
Denver CO
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: ph
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051
Guys,
I have an just finished upgrading to 8.1.7 on all my boxes some of which are
Windows2000. I have had no problems with Sun Solaris, HP and Windows NT4.0.
But on Windows2000, every time the box is rebooted the instance does not
come up automatically. However the service shows as running. I
Title: OT: RE: financial problems with fatcity.com
Guys
like Lewis, Adams, Uni-Bomberism, etc.
both
add value and get advertising for their own
sites/products. I think it balances out well
enough
to not worry about it. For me, I'd be
happy
to see them get a free ride, but would
rather
I'll throw in $20. Let me know where to send it.
Best regards,
Jonathan Gennick
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jonathan Gennick
yea unfortunately. I've reported him the already, if i dont
hear back, i'll be reporting him to his upstream provider also.
joe
[EMAIL PROTECTED] 08/30/01 12:16PM
Uh-oh - anyone else get this ??-Original
Message-Sent: 30 August 2001 09:56To:
[EMAIL PROTECTED]Want a FREE way to
Jerry,
Be aware that the system performance degardes drastically while truss is
running.
Rao
Maheswara Rao
-Original Message-
Sent: Thursday, August 30, 2001 11:36 AM
To: Multiple recipients of list ORACLE-L
Hi, Jerry,
Next time you see top output like shown below, please provide
Title: RE: RE: financial problems with fatcity.com
Ross is that all you are contributing? Two cents?
-Original Message-
From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 12:22 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: RE: financial problems
i'd think if u are abandoning oracle for M$, then check their website, i'm
sure they have a way to do it, just like oracle's website has a way to go TO
oracle FROM M$.
joe
[EMAIL PROTECTED] 08/30/01 12:06PM
Hello Folks,
I am looking for some cool script to move all the database objects
Title: RE: PEOPLESTAFF'S TOOL FOR ENTERPRISE IT JOB SECURITY
yep. is the list selling our email's to ease the financial woes? ;-)
-Original Message-
From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 12:16 PM
To: Multiple recipients of list
Let's start a campaign for Hunger !
-Original Message-
Sent: Thursday, August 30, 2001 12:28 PM
To: Multiple recipients of list ORACLE-L
I'll throw in $20. Let me know where to send it.
Best regards,
Jonathan Gennick
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com *
Actually char has some minor performance advantages over varchar2 when the
column is frequently updated to a larger size since the full space is
already claimed within the block.
-Original Message-
Sent: Wednesday, August 29, 2001 6:58 PM
To: Multiple recipients of list ORACLE-L
Isn't
Title: RE: Tkprof output
Lee,
This query seems suspect
UPDATE VM_LIVE.SINGLE_CUSTOMER_HISTORY SCH SET VISIBLE=1
WHERE
ACXIOM_CUSTOMER_KEY = :b1 AND VERSION_NO = :b2
because of this
call count cpu elapsed disk query current rows
--- -- -- -- --
Yep I got it too ... twice ...
This one heads straight to junk email senders list ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect
Dear list !
There is a column of datatype RAW in a table.
it contains 4 numbers (4 bytes each) and a string of 54 bytes , that are
concatenated and then converted to RAW by an external C++ application.
I need to convert it back in a PL/SQL trigger.
I.e. i need retrieve that RAW column , and
Title: Message
Easy.
Use SQL*Server's DTS (data transformation services) to pull the data from Oracle
into SQL*Server.
Jon Walthour
-Original Message-From: Apps Sol
[mailto:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 12:07
PMTo: Multiple recipients of list
Title: RE: OT: football fan-hood
Well,
I'm trying to get her to like hockey...that's a good hobby,
right?
Jim
__ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise
Pharmacia Corporation 800 North Lindbergh Blvd. St.
Are you on 8i? Then you can use BULK binding which will definitely give you
some speed. IF you need example ... let me know.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed
List,
Has anyone deployed WebDB 2.2 on Linux RedHat 7.0 yet. The install manual states that
it is for RH6.0 with Oracle 8.1.5, 8.1.6. I understand the process of loading 8.1.7 on
7.0 and have the glib's for 2.1 available . Do I follow the glib linking process for
installing 8.1.7 on RH7.0 and
Maybe he has to sober up to avoid the issuing of beat downs from his wife?
-Original Message-
Lee - lerobe
Sent: Thursday, August 30, 2001 12:02 PM
To: Multiple recipients of list ORACLE-L
Beat me to the punch John, however Jims analysis of the day transcends all
of that.
The only bit
I think it's that pass out part she's upset with :)
From: HAWKINS, JAMES W [IT/1000] [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: OT: football fan-hood
Date: Thu, 30 Aug 2001 07:00:51 -0800
Lisa,
I, for one, hold you
Title: RE: RE: financial problems with fatcity.com
No,
I'll do a bit more than that!
mysterious smile
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Thursday, August 30, 2001
11:48 AMTo: '[EMAIL PROTECTED]';
'[EMAIL PROTECTED]'Subject: RE: RE:
I received it a few days ago along with a couple of other items like this. I just blew
them away as I didn't solicit them.
ROR mª¿ªm
[EMAIL PROTECTED] 08/30/01 12:16PM
Uh-oh - anyone else get this ??
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
This Manufacturing Client located near Harrisburg, Pennsylvania needs an
Oracle DBA
to join its' I.T. staff.
The selected candidate will receive general direction from the Sr. DBA
and Director of Application Services however, independence is encouraged for
the day-to-day operations.
*
You bet. Maybe they can split the cost with OraStaff.
-Original Message-
Sent: Thursday, August 30, 2001 12:16 PM
To: Multiple recipients of list ORACLE-L
Uh-oh - anyone else get this ??
-Original Message-
Sent: 30 August 2001 09:56
To: [EMAIL PROTECTED]
Want a FREE way to
I thought I'd pass on the solution to a problem we just experienced trying
to install Oracle 8.1.7 on to a box running Linux Kernel 2.2.16 (Red Hat
7.0):
The install of Oracle8i (8.1.7) Standard Edition on this Intel box went very
well except when it attempted to create the sample database.
Raganath,
Sounds like you got some bad SQL operating. Usually the error you are
seeing is caused not by the shared pool being too small (although if it's
too small for you're trying to do, nothing will help), but rather by
excessive fragmentation making the requisite amount of continuous free
Title: sql*loader datatype question
I'm hitting a wall here. I'm trying to load data into a large table. Two of the fields are phone numbers (10 digits). The database field is defined as number(10).
When I try to load these records, they err out with an error similar to below.
Record
1 - 100 of 226 matches
Mail list logo
