Title: using stored procedures from pro*c
Okay
guys after feeling like a purist and that NULLS should not be stuffed with
values just because - because of course maybe slight performance
issue, also is it really the same meaning? and wanting easy way to
build in consi
Ahhh. So many ways of doing it. Thanks to all who replied and those who
attempted to.
Cheers,
Ross
> -Original Message-
> From: Cary Millsap [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 1 August 2002 15:38
> To: Multiple recipients of list ORACLE-L
> Subject: RE: UNIX Q: How do I delete
Unfortunately, MS SQL Server's GUI tools are better in that it is actually
useful and it works. How come? Most of my younger peers prefer to use SQL
Server (never mind it's shortcomings) simply because it's more GUI than
Oracle - hence easier
Oracle is losing the future here by screwi
Y'know, if it were me, I'd do...
rm -i '#Column' ...
This way I get to say yea or nay to each file, and there
are no rude surprises when I'm done.
Just my 2¢ worth...
Mike
-Original Message-
Sent: Wednesday, July 31, 2002 10:38 PM
To: Multiple recipients of list ORACLE-L
rm '#Colum
Charlotte Oracle Users Group
Covers: 'Oracle Performance Management - A Radical Approach'
(Performance Tuning One day Seminar)
By: Gaja Krishna Vaidyanatha
When: Thursday, August 29th 2002 Between 07:30 AM and 05:30 PM
To Register: Please visit www.cltoug.org to download the forms
rm -f \#* will do the trick.
On 2002.08.01 00:33 Ross Collado wrote:
> Hi,
> I have files like:
> #Column
> #This
> #
>
> How do I get rid of these 3?
>
> Rgds,
> Ross
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ross Collado
> INET: [EMAIL PROT
Now, that sounds like a very serious design business. My advice would
be to
contact some of the top names in the IT world, like Dr. James Martin.
On 2002.08.01 00:53 Rahul wrote:
> list, i have been assigned the job of documenting the scope for a data
> warehouse
> for a central bank !! the prob
Title: RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA
You're on target there. Don't start. It's not just a job it's an adventure.
I must say that I used the DBCA twice. After cleaning up the mess it made the first time, I just had it create the scripts for me. After 'fixin
rm '#Column' '#This' '#'
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- NCOAUG Training Day, Aug 16 Chicago
- Miracle Database Forum, Sep 20-22 Middlefart Denmark
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas
-Original Mess
-- Ross Collado <[EMAIL PROTECTED]> on 07/31/02 20:33:22 -0800
> Hi,
> I have files like:
># Column
># This
>#
>
> How do I get rid of these 3?
escape/quote the char's:
rm -f "./# Column";
or, if you use bash, the tab key is rather helpful for this.
simplest fix may be to:
cd
I assume that you are talking about Unix is so the use rm "#Column" to get rid of it
Cheers
--
=
Peter McLarty E-mail: [EMAIL PROTECTED]
Technical ConsultantWWW: http://www.mincom.com
APAC Technical Services Phone: +61 (0
list, i have been assigned the job of documenting the scope for a data
warehouse
for a central bank !! the problem is.. that none of us (including the IT
devision of the bank)
has any idea on what kind of "things" to include !!!
i would appreciate inputs (off-list) from anyone who has experie
Hi,
I have files like:
#Column
#This
#
How do I get rid of these 3?
Rgds,
Ross
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ross Collado
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
Unfortunately, we have no choice but to use the java-infested, half-baked
ruinStaller.
Don't even get me started about the DataBase Cremation Assistant!
Don Granaman
[OraSaurus]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, July 30, 2
Are you are implying that India can't be better?
ltiu
On Wednesday 31 July 2002 20:13, Jos Someone wrote:
> Based on the services we got from Oracle Support there, I can't imagine
> what the Oracle software will be like if they move the development over
> there Ray Stell <[EMAIL PROTECTED]
Based on the services we got from Oracle Support there, I can't imagine what the Oracle software will be like if they move the development over there
Ray Stell <[EMAIL PROTECTED]> wrote:
Heard on the BBC radio at lunch that Oracle Corp. is moving alot ofoperations to India, 1800 new jobs.
Bring on the IWW (Wobblies). Solidarity forever.
Henry
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 31, 2002 4:55 PM
>
> I would not treat this snip of news in such a light-hearted manner.
> Comparing to couple of years ago, t
as a knitter, trust me, take up some other line of work! you aren't
gonna make money on handknit goods
--- "Gogala, Mladen" <[EMAIL PROTECTED]> wrote:
> I've already bought a set of knitting needles.
>
> > -Original Message-
> > From: Weaver, Walt [mailto:[EMAIL PROTECTED]]
> > Sent
>-Isn't that an admin's dream? Having all desktops and servers administer
themselves?
My dumn ass NT admins don't need this, they are worthless all by themselves. I have
been asking for two weeks now to get a job scheduler software loaded to replace the
crappy 'AT' program for my backup and m
Title: using stored procedures from pro*c
It is meaningless. PL/SQL blocks handle their
own cursors within a single cursor employed by PRO*C, so the contents of
"sqlca.sqlerrd[2]" are likely leftover from a previous call? You may have
gotten the value you wanted in one version, but I wouldn
And for technical info on setup of Heterogeneous services try the following:
I found note 114820.1 helpful - "QUICK START GUIDE: WIN NT - Generic Connectivity
using ODBC"
Also note 109730.1 - How to setup generic connectivity (Heterogeneous Services) for
Windows NT
Also note-107227.1 setup an
He speaks the language of corporate America, bull sh*t.
-Original Message-
Sent: Wednesday, July 31, 2002 3:16 PM
To: Multiple recipients of list ORACLE-L
Is Larry Ellison learning how to speak Hindi?
> -Original Message-
> From: Ray Stell [mailto:[EMAIL PROTECTED]]
> Sent: Wed
I do not know how many of you actually work for Oracle, but for others
(Developers who use Oracle Technology) this I do not think is immediate
cause for concern. There is no way a team half the world away can solve the
business problems of a company in the US byt creating IT solutions.
Oracle's m
I think I am jumping into this thread a bit late. Take a look at
http://www.unixodbc.com for some good info on ODBC on Unix.
I am not sure where to get Oracle ODC drivers for Unix. Try installing a
Unix client and see if it comes along with it...
Babu
Robertson Lee - lerobe <[EMAIL PROTECTE
If you attend a database class in school they will tell you table
names are always plural. Each row in a table represents one instance
of an entiry e.g. each row in Employees table represents (attributes
of) one single employee. A table represents all rows/instances of the
entiy (employee) collect
If this is the way you want it then why is the need for a separate table?
I understand separate table is good when you have repeating groups
(one-to-many) or it's an independent attribute/entity.
-Original Message-
Sent: Wednesday, July 31, 2002 6:27 PM
To: Multiple recipients of list OR
Hi,
How did you identify this is the statement which is causing the problem ? Did
you check v$latch_children for the library cache children ? I would assume if
it's one single SQL, then the contention will be on one child latch and not
distributed across all the library cache latches. If this
Anybody have any experience with Microsoft Txn Server? I am running into
issues with a few Windows2000 servers running Microsoft Txn Servers that are
connecting to my 8.1.7.4 HP-UX database. There are several concurrent txns
running that do a lot of inserting and data loading. Most of the time
FYI, you do have the choice of running server partitioned. I'm running 10.7 character
with 8.1.7.4
with no problems.
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
"The problem with some people is that when they aren't drunk, they're sober."
--William Butler
Yeats.
I've run into a strange problem with Reports Manager; small reports publish
fine (in any format), but the larger ones error with a phony space message
for fnd_documents_long_text coming from the client. There is plenty of space
in the applsys tablespace.
I've had an open tar for months, only t
Hi Gene,
I've tried using both a logical (ora_system) and the full path. It doesn't
work either way.
Tom -
I'm tempted but I would like the simplicity of maintaining a single
init.ora.
Mark
-Original Message-
Sent: Wednesday, July 31, 2002 3:34 PM
To: Multiple recipients of lis
The good thing is that you can only work 1 corner at a time. I got to pick up a used
wheelchair and go for the sympathy work :)
*so many corners so little time*
>>> [EMAIL PROTECTED] 07/31/02 05:50PM >>>
Guess I'll make out a sign now which reads, "Will code for food" and hang
out at a busy in
igor:
I agree with what you say here, as well as your previous comment about
deleting a laid-off employee and then the extra step of finding the orphan
addresses. Our developers have imbedded this inverse logic throughout the
application. and now I'm left to try to figure out how to validate da
Waleed,
We are running different versions from 7.3.4.5 to 9i. Ver 7.3.4.5 is for
Oracle Financials 10.7 Char and company not yet decided to go for
Application 11i so we have to support it for a while and face all such
limitations ver 7.3.4.
Sorry no choice but to live with it.
Regards
Rafiq
Addresses is the parent (so it will not be orphaned). It's up to the
business rules to decide to keep addresses when a employee get fired or not.
If cleaning is required then it's easy to do.
Many of the application these days like to keep a table with all US
addresses.
The idea is always to sim
Jared,
What do you think of those values, what should I pay attention ?
tia
Ramon
EVENTTOTAL_WAITS TOTAL_TIMEOUTS
TIME_WAITED AVERAGE_WAIT
--- --
---
db fil
What I'd do first would be to profile the httpd processes by compiling
Apache
and Tomcat with "-g" flag (for gcc) and then use gprof, pixie, hrprof or
oprofile
on the resulting output files. Oracle is not compiled with "-g", so
profiling
will stop when it encounters a routine from libclntshr.so,
Title: RE: data modeling question - child table with multiple parents
> From: Igor Neyman [mailto:[EMAIL PROTECTED]]
>
> here is an argument against this solution:
>
> in current economy, some day you'll have a lay-off, and you'd want to
> "delete" an employee (you will be laying off employe
meant "our life-time"
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 31, 2002 5:21 PM
> well, eventually all those living expenses will even up (along with the
> salaries), but not in ou
This is the result of the query you send. Hope the out
put is readable
EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED
AVERAGE_WAIT
buffer deadlock 3 3 0 0
instance state change 2 0 0 0
library cache lock 6 0 .04
.
seems to me like a case of "inverse" logic.
is it "employee" (or "supplier", or whatever) entity, which has "address"
attribute, or is it "address" entity, which has "employee" (or "supplier")
as an attribute?
for me, it's the first: I'm not interested in any address, if it does not
belong to "emp
I use ifile w/out a problem in OpenVMS. Do you reference it w/ full path or logical?
I don't like using init...ora and config...ora. I use an instance specific
initSID.ora that ifile's a common init.ora file into each db. Its nice to put a
change in 1 file and its applied to all dbs.
Gene
Guess I'll make out a sign now which reads, "Will code for food" and hang
out at a busy intersection.
-Original Message-
Sent: Wednesday, July 31, 2002 3:04 PM
To: Multiple recipients of list ORACLE-L
Anybody read Bob Lewis' Survival Guide column in InfoWorld? A few weeks ago
he talked
Sounds great! we will need to get a green card to INDIA to get our jobs back
:(
-Original Message-
Sent: Wednesday, July 31, 2002 5:04 PM
To: Multiple recipients of list ORACLE-L
Anybody read Bob Lewis' Survival Guide column in InfoWorld? A few weeks ago
he talked about programming jobs
here is an argument against this solution:
in current economy, some day you'll have a lay-off, and you'd want to
"delete" an employee (you will be laying off employees - not addresses,
right?), then you'll have to take "additional" care not to leave "orphan"
addresses, and all this headache, only
Which is why I'm a DBA (wannabe). Until 10i, when I'll be obsolete, too.
;)
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
> -Original Message-
> From: Weaver, Walt [mailto:[EMAIL PROTECTED]]
> Se
Your unstated business rule is that no employee can have the same address
as a supplier.
My first thought is that the ADDRESS table has a primary key, generated via
a sequence. EMPLOYEE and SUPPLIER each has a foreign key to that primary
key. Do you really care whether an ADDRESS is the addres
I've already bought a set of knitting needles.
> -Original Message-
> From: Weaver, Walt [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 31, 2002 5:04 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Oracle Corp. move to India
>
>
> Anybody read Bob Lewis' Survival Guide
And if it isn't broken yet, SP3 can automatically download patches and
upgrades for you, so it can break even more on it's own now.
Isn't that an admin's dream? Having all desktops and servers administer
themselves?
Rich Jesse System/Database Administrator
[EMAIL PROTE
I would agree with you and become a pro-globalization if US imports labor
from India to build houses in US.
But globalization always work one way!
Any views or opinions presented in this email are solely those of the
author and do not necessarily represent those of the company
-Original M
well, eventually all those living expenses will even up (along with the
salaries), but not in out life-time :-)
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 31, 2002 4:55 PM
>
> I would
If you can't bring Indians with H1-B visa over to Oracle, then bring Oracle
over to the Indians.
On Wednesday 31 July 2002 13:48, Khedr, Waleed wrote:
> He is learning how to lower development costs, increase his profit margin,
> and increase US unemployment.
>
> Waleed
--
Please see the offici
Tom, this is for OPS. Not using IFILE means duplicating a lot of
parameters
for each instance.
Jared
"Mercadante, Thomas F" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/31/2002 02:04 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECT
Supplier
Supplier_id is pk
col2
col3
supplier_address_id fk references addresses (address_id)
Employee
=
Employee_id is PK
col2
col3
employee_address_id fk references addresses (address_id)
Addresses
=
Address_id is PK
zip code
street
etc
The address table is the pare
yet, another solution:
add another table, called i.e. "ACTOR" (actor_id, actor_type);
sub-entity tables "EMPLOYEE", "SUPLLIER", "CONTRACTOR" will store sub-entity
specific information, and their PK (employee_id, supplier_id, ...) will be
foreign keys to actor_id in "ACTOR" table;
table "ADDRESS"
Thanks Tom, I wish I'd said that.
Haven't done enough modeling lately...
Jared
"Magaliff, Bill" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/31/2002 02:10 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subj
What does this tell you?
select
event,
total_waits,
total_timeouts,
time_waited/100 time_waited,
average_wait
from v$system_event
order by time_waited
/
Johnson Poovathummoottil <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/31/2002 01:24 PM
Please respond to ORACLE-L
Anybody read Bob Lewis' Survival Guide column in InfoWorld? A few weeks ago
he talked about programming jobs in the U.S. going the way of manufacturing
jobs, with more and more going overseas to developing countries.
He claimed that programmers/developers will be going the way of textile
workers
yes it does help - thanks
only potential issue with my second option is that the different parent
tables may be distributed and not located in the same node - in that case
using a straight FK is out, right? (both parent and child would have to be
on the same node?) but what about a trigger in a d
> model a child table that has multiple
> parent tables
Consider reversing it. Model one parent (ADDRESS) and two child (CUST,
EMP). Parent is super-type that has the attributes common to both, e.g.,
name, address, city. Children have attributes unique to them, e.g., CUST
has sales_rep_id, cu
Since the ADDRESS table is just a look-up table, why not let it have a
primary key for each address and then let the EMPLOYEE and SUPPLIER tables
reference it with a foreign key? That does not prevent the EMPLOYEE and
SUPPLIER tables from having their own unique primary keys.
-Original Messag
Bill,
There are other approaches as well.
A table for each type of address. This allows you to have foreign keys.
You can use use a view to pull all the tables together, and just include
the discriminating column in the view.
It's an option, but not one I personally care for.
Another is simil
thanks, tom . . .
your second option is one I had suggested below, which in may ways is
preferable - easy to track FK relationships, cascade delte, enforce r/i,
etc.
your first option won't work in our case - the parent tables are too
dissimilar to enable us to combine them - more real life exam
Bill,
simply combine the employee, supplier, contractor and vendor tables into one
such table titled "people". Add a column to indicate what type of record it
is (a code indicating one of the above). solves your problem.
if this is not possible, then the address table could have multiple colum
Mark,
throw away the IFILE thingy. it is not worth the trouble!
create instance specific init.ora files.
solves your problem.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, July 31, 2002 4:49 PM
To: Multiple recipients of list ORACLE-L
Greetings
Your developers aren't unique :-)
personally, I don't see any evildoing in caching some stuff on the client
side.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 31, 2002 4:24 PM
> Hi Al
I would not treat this snip of news in such a light-hearted manner.
Comparing to couple of years ago, the IT job market has slumped completely
from a sellers market to a buyer's market. I am not a greedy person by any
means and all I asking for is a decent salary and some job security. But if
thi
On Wed, Jul 31, 2002 at 12:15:39PM -0800, Gogala, Mladen wrote:
> Is Larry Ellison learning how to speak Hindi?
No, but I believe he is fluent in several "markup" languages...tippy boom.
> > -Original Message-
> > From: Ray Stell [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, July
For US they want us to be OCP, OCA but it does not matter if you outsource
the code development offshore!
Waleed
Any views or opinions presented in this email are solely those of the
author and do not necessarily represent those of the company
-Original Message-
Sent: Wednesday, J
He is learning how to lower development costs, increase his profit margin,
and increase US unemployment.
Waleed
Any views or opinions presented in this email are solely those of the
author and do not necessarily represent those of the company
-Original Message-
Sent: Wednesday, July 3
Greetings elitist *nix bigots,
I'm starting to upgrade our OPS databases on OpenVMS from 7.3 to 8.1.7.3 and
I've run into a problem with the IFILE parameter in the node specific init
file.
It appears Oracle is not reading the generic init.ora specified in the IFILE
parameter in the node specific
Thanks. My win2k server has been having a problem lately. I wonder if any
of their fixes might patch a hole that I think someone came thru. I believe
the server is currently compromised .
-Original Message-
Sent: Wednesday, July 31, 2002 2:54 PM
To: Multiple recipients of list ORACLE-
Good day, all:
Am curious to hear opinions on how to model a child table that has multiple
parent tables (i.e., foreign key to multiple parents)
Example:
There's a table that stores Addresses (table ADDRESS) for both employees
(table EMPLOYEE) and suppliers (table SUPPLIER).
Each of these table
>From the NYT:
IBM announced yesterday that it planned to buy PricewaterhouseCoopers
Consulting for $3.5 billion. The move will accelerate I.B.M.'s shift from
selling just computers and software toward a future of providing information
technology to corporate customers as a utility-like service.
Yes,
India deserves that.
Ray Stell wrote:
> Heard on the BBC radio at lunch that Oracle Corp. is moving alot of
> operations to India, 1800 new jobs.
> ===
> Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
> --
>
does that mean 1.2 billion new DBA's ???
-Mensaje original-
De: Gogala, Mladen [mailto:[EMAIL PROTECTED]]
Enviado el: Miércoles, 31 de Julio de 2002 16:16
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Oracle Corp. move to India
Is Larry Ellison learning how to speak Hindi?
Title: using stored procedures from pro*c
When calling a stored procedure (to do a select)
from a pro*c program, does the sqlca.sqlerrd[2]
row counter get set? Or does that
happen only if you are putting the selects into
the Pro*C program?
It seems to act differently for different
version
Hi All,
We have an application which executes one sql
statement more than 10 million times a day. Everything
is good about the sql, well tuned, uses indexes, parse
only once, etc. The number of concurrent users in this
database seems to around 60, but we see an average
1500 executions/sec.
We qu
Title: RE: Jared, please do something
Way to
fan the flames
John P Weatherman Database Administrator Replacements Ltd.
-Original Message-From: Gesler, Rich
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 31, 2002 2:18
PMTo: Multiple recipients of list ORACLE-LSubject: RE
Is Larry Ellison learning how to speak Hindi?
> -Original Message-
> From: Ray Stell [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 31, 2002 3:40 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Oracle Corp. move to India
>
>
>
> Heard on the BBC radio at lunch that Oracle
Title: RE: driving me crazy
Creating mater. view - can't because error:
ORA-01723: zero-length columns are not allowed
It is giving me error supposedly on join???
How do I know which column - can I specify column size in create statement??
Just for info in case some people might not know, URLs for Oracle-related
news:
http://www.orafaq.com/faqnews.htm
http://www.newsnow.co.uk/cgi-bin/NewsNow/NewsFeed.htm?Topic=*.Tech&Section=A
SearchW&Search=Oracle&ASearch=Oracle,Ellison,SQL
There are minor differences between the two sites, but
Title: RE: Ids and passwords for application users
> -Original Message-
> From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
>
> I think the real issue is who is going to keep the usernames
> and passwords
> maintained. Is it you? Do you have that much spare time?
At my previous empl
My point exactly. The failure COULD leave a stray temp segment in the
tablespace that could cause the second attempt to fail. I have not been able
to recreate it, so I am not certain exactly the behavior of dba_free_space.
But I do recall a similar situation on 7.3 years ago.
-Original Messag
Someone forwarded me this just now:
FYI
Windows 2000 SP3 is being officially released tomorrow but is
available on the web today.
It incorporates literally hundreds of hotfixes plus some new
features required by Microsoft's antitrust agreement.
(MS pu
The DBA usually does not get to decide how the application is developed in
most of the cases. We have to manage what's out there. There are some products
which use one login for all users and manage security within the application.
If the applications is web enabled, the changes are the DBA
Heard on the BBC radio at lunch that Oracle Corp. is moving alot of
operations to India, 1800 new jobs.
===
Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
--
Please see the official ORACLE-L FAQ: http://www.orafaq
Any plans for Oracle upgrade? :)
Waleed
-Original Message-
Sent: Wednesday, July 31, 2002 3:17 PM
To: Multiple recipients of list ORACLE-L
Rich,
Thanks for reply and your explanation. For ver 7.3.4 dba_free_space specify
large extent available but when using initial extent of around
I don't think administering usernames should be the DBAs responsibilty. There
are better things to do than create/manage hundreds of users.
But there are applications (for instance Siebel) which require you to create
individual logins for each user. We have handled that by creating a pack
Lee, are you trying to use your Unix machine as an ODBC client or as
a database server server? If it is supposed to be a database server,
things are easy and trivial. If your unix box is supposed to be a client,
you can find an some ODBC drivers at http://www.unixodbc.org/ . I've never
tried usi
Rich,
Thanks for reply and your explanation. For ver 7.3.4 dba_free_space specify
large extent available but when using initial extent of around that size ,
it never creates initial extent of that size and generate error so I am not
relying it and instead using this query. However I am not usi
Call me what you like, I really don't care.
There are bigots on both sides of the MS/Unix fence. I happen
to prefer unix, but tolerate both types of bigots, and even work
with NT/Win2k extensively.
What I don't tolerate well are tirades and name calling.
100% of email from folks reading this t
Joshy,
In some versions of 8i there were bug related to OCI driver where
closing Statements and ResultSet aren't enough, you have to close
Connection which is obviously not good for connection pooling.
Not sure if 9i could have this problem too.
Also, check on how you close the Statements and Re
Title: RE: Jared, please do something
I'm
sure that folks who have Unix email can handle this somehow.
I must
admit, it was pretty amusing reading the thread, but I subscribed to this
list for the technical level and content, not for cyber-pissing
contests.
Personally, I use the tool (ha
I concede your point
btw -- my 12 year old car has the combination lap/shoulder belt :)
--- Cary Millsap <[EMAIL PROTECTED]> wrote:
> Assuming reliability in something that's inherently unreliable
> creates
> danger. The experienced learn to ignore naming standards, as you
> describe below. The
Hi Rafiq,
Right, PARALLEL does do that, which is why I had stated in the original post
that I had tried the CREATE without PARALLEL after coalescing the TS.
In the meantime, I have figured out what the problem is. My problem is on a
test system. This test system's "MYCOOLTBL" happens to be par
But it was said that it failed even with noparallel
-Original Message-
Sent: Wednesday, July 31, 2002 1:56 PM
To: Multiple recipients of list ORACLE-L
I have not been able to duplicate the scenario, so I'm only guessing here...
(consume with 1 large grain of salt).
When you specify par
Title: RE: Jared, please do something
I
think every body is over-reacting here. O/S is not a religion. I do not care if
it's UNIX or Windows or whatever!
My job
is to make what we have running to run better.
Take
it easy , it's not worth it, life is already very stressing!
Waleed
--
Title: RE: Jared, please do something
bigot ;o)
-Original Message-From: Gesler, Rich
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 31, 2002 1:18
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Jared, please do something
That
won't work...obviously everybody is
Title: RE: Jared, please do something
That
won't work...obviously everybody is on Unix here.
-Original Message-From: Straub, Dan
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 31, 2002 2:03
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Jared, please do somethin
1 - 100 of 205 matches
Mail list logo