Thanx guys.
my next call is to Oracle Customer Support.
_
Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year.
http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus
--
Please see the official ORACLE-L FAQ:
Thanx guys.
my next call is to Oracle Customer Support.
_
Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year.
http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus
--
Please see the official ORACLE-L FAQ:
i just need to create a data capture program...which does not require any
validation...just like forms..and the data i need to put in oracle
table...
santosh
-Original Message-
Sent: Tuesday, March 18, 2003 8:09 PM
To: Multiple recipients of list ORACLE-L
Santosh:
Would this project
Thanks
to all who replied...
santosh
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Stefan JahnkeSent:
Tuesday, March 18, 2003 6:54 PMTo: Multiple recipients of list
ORACLE-LSubject: AW: From Microsoft Access to
Oracle
Hi
We
ext
Hi all,
I noticed an interesting error, I tried to use Oracle Expert in order to tune my database but it won't go further after noticing some temporary tables, and actually Expert asked to delete those objects.
Is that normal behaviour or a bug.
Rgds,
JoshuaGå före i kön och få din sajt värderad på
My Financials
person is out, what might the following imply?
"I am currently working on a new tax book to the current Oracle fixed
assets
and I would like to copy the data from production to the test
environment.
I would like to add some major changes to these assets in the test region
Title: RE: How to calculate the working hours?
see answer below
> -Original Message-
> From: Andrea Oracle [mailto:[EMAIL PROTECTED]]
>
> We have open Time for every order, ef:
>
> Open Time
> --
> 03/12/03 11:08:07
>
> How to calculate the working hours (8am - 5pm
To setup your environment add the following to your .profile or script.ksh
export BELL=`tput bel 2>/dev/null`
export BOLD=`tput bold 2>/dev/null`
export BLINK=`tput blink 2>/dev/null`
export PLAIN=`tput sgr0 2>/dev/null`
export UNDERLINE_ON=`tput smul 2>/dev/null`
hi all,I need your help, I have a problem while configuration database
progress.while progress until 46% I got a error message like this
:"ORA-12705: invalid or unknown NLS parameter value specified"after that
I can continue the configuration.could anybody help me?Thank
you Regards, pomin
-Original Message-
Sent: Tuesday, March 18, 2003 4:34 PM
To: Multiple recipients of list ORACLE-L
Working on an wrapper for Oracle functionality.
Any of the Unix guru's know if you can
highlight or set text blinking in the korn shell
in unix?
Brian
-
"It'd be an abomination!
ODTUG is not Oracle. It's an independent user group. But you'd still think
Oracle would give them a sweet deal. :-)
Dave
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 17, 2003 1:41 PM
> To: Multiple recipients of list ORACLE-L
> Subject:
I'm no unix guru; but I know this.
Place the text to be highlighted inside the strings ^[[7m and ^[[0m. the
^[ character is typed by a Control-V followed by a Control-[. for instance
place the text to be highligted "Oracle" as
^[[7mOracle^[[0m
HTH.
Arup
- Original Message -
To: "Multipl
You might want to read up on tput.
Jared
"Spears, Brian" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/18/2003 02:33 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Unix tip for oracle
Work
Patrice
Ron just gave me an idea that might provide the answer you need. Oracle
tries to have a major release every 18 months. Estimate the amount of
training you would need to become proficient in the new release, then spread
that over 18 months. Just an idea.
Dennis Williams
DBA, 40%OCP, 100%
I found the hash function, but that is only one bit. The next problem is to
find the segments.
Come to Copenhagen in October and you will see ;-)
Anjo.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, March 18, 2003 11:18 PM
> Well Anjo,
Working on an wrapper for Oracle functionality.
Any of the Unix guru's know if you can
highlight or set text blinking in the korn shell
in unix?
Brian
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Spears, Brian
INET: [EMAIL PROTECTED]
Fat City Network Services
Please note that there is still a bug for null wait event with 9.2.0.3.0. Oracle
promised that it will be fixed with 9.2.0.3.0 but it has not. The bad news is that it
has no ETA for it. Hopefully it will be fixed with 10i or 11i.
Without fixing this bug, it is very hard to identify the performan
Well Anjo, what sort of hash? I've been working to develop the stuff
that Hailey talked about(direct SGA access) at Hotsos seminar but the
best I've come up with so far has me sorting through all the shared
memory segements seeing which one I can attach to. This is not good. I
can get the id's t
I am going to start some experiments soon but
any prior input from the field will be helpful.
In order to set up a test 9i RDBMS/9i ifs/ 9iAS
environment on Solaris Sparc hardware, how much
RAM is the minimum required? Oracle docs apparently
suggest 1 GB. I suspect Java will be the killer here,
b
Title: RE: ERWIN vs Designer
Assuming you can't just use the Access Relationships editor to do this (if all you're doing is drawing the diagrams, I'd use the diagram that's already there), ERWin has a much easier learning curve. It's bloated, but it works.
> -Original Message-
> From
> When I generate SQL report in Unix OS, while printing it skips a
> page each time. How can i overcome that.
Don't print it.
But seriously, some more details are needed for anyone to help.
Reply to the list, not me. I know nearly nothing about SQL Reports,
and I like it that way.
Jared
Patrice,
You actually get your employer to send you to training?? Lucky you..
If you consider the amount of training that Oracle offers when a new
release of the database occurs I would think that you can get a solid
idea of the training needed to be "up-to-date". Add into that the OCP
training
I have been tasked with the responsibility of reverse engineering over 2500
small Access databases to get a picture of all the information that our
users are capturing (schemas, data models etc) to see if we can incorporate
their requirements into our production systems and stop them from creating
Title: Re: Amt of Training to be considered "up to date"
That
should read: "employer" not "employee"
Pat.
-Original Message-From: Boivin, Patrice J
[mailto:[EMAIL PROTECTED]Sent: Tuesday, March 18, 2003
1:45 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: Amt of Tra
He's down Jared quick kick him! Kick Him!
Seriously Kevin I wish you the best of luck in your job search. Hope it all
works out.
Alec
-Original Message-
Toepke
Sent: Tuesday, March 18, 2003 10:09 AM
To: Multiple recipients of list ORACLE-L
Greetings!
I hope Jared doesn't kick me off t
That means that it's going to achieve the ultimate stability in 3 years?
The same stability that was achieved by VMS and RSX?
-Original Message-
Sent: Tuesday, March 18, 2003 11:49 AM
To: Multiple recipients of list ORACLE-L
Stephan,
I am wondering why would you not rate Tru64 as a stab
Where can I apply for being a Khalif of Bagdad? There is going to be
a vacancy fairly soon.
-Original Message-
Sent: Tuesday, March 18, 2003 1:44 PM
To: Multiple recipients of list ORACLE-L
I hear the job of Prime Minister in England will probably be open soon. Any
political ambitions
Title: Re: Amt of Training to be considered "up to date"
Hi Patrice
I've never seen an
official number of weeks for training in Canada.
I know that Oracle Canada is providing 4 weeks to their
consultants. You can have more if you're in sales ...
For sure, going to
training is fun but I
Has anyone successfully run Autoupgrade with IPC?
We've been completed upgrading test cases of our HR Application (11.5.7, 8.0.6/8.1.7,
HPUX 11.0) successfully until this last test where I configured the workers to use the
IPC protocol. Autoupgrade runs for several hours okay and then bombs w
On top of Cary's comment regarding how long
the interval was between the execute and the
fetch, there is the implied question "What was
being sent to the client".
Looking at the stats, I think the answer is
"NOT the data" as we see r=0 - no rows
returned by the query.
My guess would be that the
>> How did Oracle know that the "shared memory realm already exists"?
Oracle knows this because it attaches to a segment based on the hash value
of $ORACLE_HOME and $ORACLE_SID. In that segment the $ORACLE_HOME and
$ORACLE_SID are stored, so that oracle can see to which instance they
belong.
Anj
I know that one is still wet behind the ears. I was debating whether or not to stay
on 9.2.0.1 until 9.2.0.3 has been out there a few weeks. I'd hate to see them
withdraw a patchset after I've applied it (like 8.1.6.3 or 8.1.7.2.0).
Thanks for the replies.
Jay
>>> [EMAIL PROTECTED] 03/18/03
Money, sex and power. No exceptions to my knowledge (read: so far in my life).
Connor McDonald wrote:
Stepping back into reality briefly:
With great power comes great licensing fees, great
amounts of advertising literature, great demands from
superiors to reduce costs by migrating to SQL S
Hi All,
Anybody using Veritas Database Edition for Oracle on a Sun Cluster? Any
comments or things to consider? I am being asked for opinions for our new
Sun cluster (planning on failover capabilities).
Any comments, good or bad, would be appreciated.
thanks
Tom Mercadante
Oracle Certified Pr
I hear the job of Prime Minister in England will probably be open soon. Any
political ambitions ?
-Original Message-
Sent: Tuesday, March 18, 2003 12:09 PM
To: Multiple recipients of list ORACLE-L
Greetings!
I hope Jared doesn't kick me off the list for this, but I was just layed off
t
Nope,
This will just cancel the current query *AFTER* a fetch. What you describe
means that you need to run with non-blocking oci.
Anjo.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, March 18, 2003 3:44 PM
> Out of band breaks are pim
Greetings!
I hope Jared doesn't kick me off the list for this, but I was just layed off
this morning and am now in the need of a job. I have over 10 years of
experience with Oracle, mostly using SQL and PL/SQL as a developer, but the
last 2 years have been as a development support DBA. I am curren
Andrea,
Will the following work?
table business_hours(
system_date date,
business_day_flag varchar2(1), -- Y/N to indicate a holiday
start_hour varchar2(10),
end_hour varchar2(10)) -- If Dec 31st is a working day but half-day, this
column can help you with that
This table will have an entry for
Title: Re: Amt of Training to be considered "up to date"
I
understand from your response that your employee doesn't send you on any
Oracle, UNIX or MS courses.
Regards,
Pat.
-Original Message-From: Wolfgang Breitling
[mailto:[EMAIL PROTECTED]Sent: Tuesday, March 18, 2003 12:39
Ah yes, but they've promised that all the Tru64 capabilities will be in
HP-UX by then. And of course, we always believe vendors' promises,
don't we? :)
Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihla
I can only relate personal experience. Like the umpire says: I call 'em
like I see 'em.
The older, slower Alphas do fine. However, it has been my private, somewhat
biased opinion that Compaq, lacking the advanced technical knowledge to push
the platform further, resorted to something similar to
This is trace data from 9.2.0.2+ (you can tell because of the new STAT
data). Therefore the timings are expressed in microseconds (0.01-second
units).
Technically, to answer your question, you have to know whether or not the
application invokes the fetch immediately after the execute. It proba
Stephan,
I am wondering why would you not rate Tru64 as a stable platform. We are
using it for all our OLTP and datawarehouse needs; and it has been quite
stable. It's rather unfortunate that HP is retiring it in 3 years.
Arup Nanda
- Original Message -
To: "Multiple recipients of list OR
Title: Re: Amt of Training to be considered "up to date"
52
I am not joking. I consider staying "up-to-date" a full time process, not
just something you do a few weeks a year. Perusing this newsgroup IS one
part of staying up-to-date.
At 07:49 AM 3/18/2003 -0800, you wrote:
>I am fishing
Jay,
We are running 9.2.0.3 On Tru64. Downloaded and applied just three days ago
(it came out in March 14th). Took care of two bugs I opened up with respect
to subpartition splitting and moving the index subpartition to a separate
tablespace.
Although it's too early to pass a verdict; it seems st
9.2.03?
I just see "Oracle9i Release 2 (9.2.0.2)" on Oracle's download page.
Where do you get it?
Am Die, 2003-03-18 um 17.03 schrieb [EMAIL PROTECTED]:
> 9.2.0.3
>
> -Original Message-
> From: Jay Hostetter [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 18, 2003 9:59 AM
> To: Multiple
Title: RE: Usage of mySQL in enterprise environments
We're a big user of MySQL here and I wouldn't compare it to MS Access any more than I would compare Oracle to MS Access. MySQL has made great strides in the last couple of years and once InnoDB matures a bit it'll add a lot of features that
Title: RE: 9i - Which Patchset
9.2.0.3
-Original Message-
From: Jay Hostetter [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 18, 2003 9:59 AM
To: Multiple recipients of list ORACLE-L
Subject: 9i - Which Patchset
Any opinions on which patchset of 9.2 is most stable: 9.2.0.1, 9.2.0
Title: RE: 9i - Which Patchset
There are some serious security bugs that you have to either apply patches individually or use 9.2.0.3. Also, I can't help thinking that the older releases (for the most part) contain everything in the previous patchsets plus more fixes. Therefore, if I am goin
Hi,
I haven't got too many response to my working hour
question, probably because I sent it out late Friday
night. Let me send that question again, really
appreciate your help!
--
We have open Time for every order, ef:
Open Time
--
03/12/03 11:08:0
Given my experience here, "stable" and "Tru64" don't go together. As to the
patch number, Oracle support usually requires that you be at the latest
patch level.
> -Original Message-
>
> Any opinions on which patchset of 9.2 is most stable:
> 9.2.0.1, 9.2.0.2, 9.2.0.3? We're running H
Title: RE: access to oracle $ tables in 9.2.0
I am
fishing for a standard from an official source -- is there a set number of weeks
per year of IT training one requires to "stay up to date" in our field? In
IT in general?
This
is Canadian Income Tax phraseology, maybe the same thing exist
The main difference between INB & OOB breaks is that the Oracle kernel will
get notified directly when OOB is received (a bit is set to indicate that an
interrupt happened and the Oracle kernel will check this bit every now and
then). With in band breaks the connections has to be tested (real e
Well..there's always the sneaky way
Depending on which ODBC driver is in use, it will query data dictionary
views so that the front-end tool (i.e. MS-Access, MS-Excel, etc) can display
a list of objects. I recall that the Oracle-supplied ODBC drivers tend to
start with ALL_OBJECTS while t
per Doc ID: 225324.996
adding -nojit to edited netasst fixed this problem for me on 8.1.7.4
on rh7.1. Your milege will vary like a Saudi Utility Vehicle (SUV).
$./jre -?
(SUV)va(tm) Runtime Loader Version 1.1.8
Usage: jre [-options] classname [arguments]
Options:
-dprint ru
Speaking of the amphibians, there is also a TOAD-like tool for MySQL.
It's called "tora" (http://www.globecom.se/tora) and it's free on Linux.
-Original Message-
Sent: Tuesday, March 18, 2003 9:14 AM
To: Multiple recipients of list ORACLE-L
Hemant,
MySql is akin to M$ Access. Use i
Any opinions on which patchset of 9.2 is most stable: 9.2.0.1, 9.2.0.2, 9.2.0.3?
We're running HP Tru64.
Thanks!
Jay Hostetter
Oracle DBA
D. & E. Communications
Ephrata, PA USA
**DISCLAIMER
This e-mail message and any files transmitted with it are intended for the use of the
individual or
A bunch of you asked for it, its not quite done but the majority of the
stuff should work just fine, they were originally written for 8i
database but latest development has been on 9.2.0.3, although I've tried
to NOT use any 9i specific stuff in them.
yes they are free and you can use to your hear
No, I don't think you're reading this wrong. May be you've had
a network problem or a NIC acting up?
-Original Message-
Sent: Tuesday, March 18, 2003 9:09 AM
To: Multiple recipients of list ORACLE-L
We are having some performance problems at a client. I ran a 10046 trace,
level 8 on the
The version is 8.1.6 and 8.1.7.
The reason why the first query has dba_tables in it at all is that without it,
columns that are no longer there keep showing up. In other words, there are
columns in dba_tab_columns with no corresponding table row in dba_tables. The
link to dba_tables was to we
Am Mon, 2003-03-17 um 18.32 schrieb Ray Stell:
> On Mon, Mar 17, 2003 at 07:03:43AM -0800, Joe Johnson wrote:
> > Hi,
> >
> > This site has a good description of how to use the ipcs and ipcrm commands to
> > clean up these left-over memory segments following the shutdown. I've found
> > that using
Thanks for all of the replies.
I discovered that ipcs -mo will give me the number of
current processes connected to the memory segment. The
"dead" segments left by the instance which was giving me problems
all had 0 in that column. The segment for the live instance
had about 14 processes connect
Sinardy,
Wish my favorite network GURU was in today as he could really explain this,
but regrettably he's on the road. Anyway, what their talking about is how you
interrupt the server side process that your client is talking to. Here is an
example/walk through:
You start a SQL*Plus sess
Rukmini
this list is good:
SUB ODTUG-WEBDEV-L
and Sue Harper is active on this list.
(If you don't know who Sue Harper is, find out.
She's a wonderful technical resource.)
Barb
--- Rukmini Devi N <[EMAIL PROTECTED]> wrote:
> Hi all,
>
>Can any one tell about the Oracle
> Applications(
Santosh:
Would this project require any type of reporting which is highly formatted?
If not I would Stefan recommended and us VB6 (or VB.Net, if so use the MS
Oracel Data Provider). This will give you all the functionality you will
need. If basic reports are required you could always use the
Out of band breaks are pimarily used to cancel a query or transaction. In
the new OCCI, out of band breaks corresponds to the "cancel" method in the
ResultSet class or "terminateStatement" in the Connection class. I
sort of hate this stuff. Those things used to be called ocan and obreak
and OCC
An ora 1452 error says there are duplicate keys, hence you can't create a
unique key. If it is a known, death be unto me if I am wrong, 100% fact
that the unique key was valid in the original data, the first question I
would ask is: Was this an import that is being run with commit=y ignore=y,
abo
I love this stuff! It used to be a part of quite a few error messages:
Call your local Oracle customer support representative!
-Original Message-
Sent: Monday, March 17, 2003 11:24 PM
To: Multiple recipients of list ORACLE-L
Hello,
my client has oracle v8.1.6 and v9.0.1.
we need to acc
Hemant,
MySql is akin to M$ Access. Use it accordingly for things that can be lost
forever without damage. Seriously in a MySql database each schema is a
subdirectory of where they put the database main directory. That point is not a
negotiable item either, it's in /var/mysql (if memory ser
We are having some performance problems at a client. I ran a 10046 trace,
level 8 on the DB for about 5 minutes of test operations. From the trace
files generated I find someting of the following:
SELECT Tm_trade_in_error.trade_id, Tm_trade_in_error.account_number,
Tm_trade_in_error.aps_groupid,
Hi
I think mySQL is ok, as long as you just use it to dump data into it (like
firewall logs etc.) and run reports on the data using simple SQL. But mySQL
really s$&%cks when it comes to things like subselects, inline views, stored
procedure (and I think the last time, a developer asked me somethin
Hi
We
extensively used OO4O with Access 2000. It works fine, gives you all the Oracle
specific stuff, but ... it's more work, since you have to code more
things.
I
personally think it's worth it, eventhough I wouldn't go with Access in the
first place. If it has to be VB, why not use VB 6
Hemant - We have been using mySQL for some applications. It seems to work
well for some situations, especially mostly queries. It might work well for
your information stores. Can you start on mySQL but plan on switching to
Oracle as a contingency. Since mySQL is free, you wouldn't be out a lot of
l
Let's follow the transaction and see what happens. I am sure there are
some errors and omissions, so please take with a grain of salt and add
other steps/clarifications.
1) Object resolution. If the object definition does not already exist in
the dictionary cache, it must be read from the data dict
Santosh - Hopefully someone with more Access experience will reply, but from
what I understand you want to create the Oracle table first. Access can
create Oracle tables but it tends to use goofy data types. Then Access can
connect to that table.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetou
How about list for IDS (forms, reports, ???0?
Thanks.
--- Naveen Nahata <[EMAIL PROTECTED]> wrote:
> I find these lists pretty useful
>
> [EMAIL PROTECTED] (For Apps DBA)
> [EMAIL PROTECTED] (Covers functional
> aspects)
>
> Regards
> Naveen
>
> -Original Message-
> Sent: Tuesday, M
Which version of Oracle is this ?
The views have changed over time,
and I can't spot why your first query
needs a join to dba_tables - all the
relevant columns seem to exist in
dba_tab_columns in my version of 8.1
As a general rule, when there is no
obvious quick and clean way of joining
catalog
The easiest way is to ODBC link the tables and
develop like it is an MS Access project.
This is not the best way due to security and a host
of other issues.
I have seen using ADO & oo4o through VBA
to make the connection.
This seems to work ok, but does require alittle
more coding then the a
Thanks
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, March 18, 2003 4:03 PM
> I find these lists pretty useful
>
> [EMAIL PROTECTED] (For Apps DBA)
> [EMAIL PROTECTED] (Covers functional aspects)
>
> Regards
> Naveen
>
> -Original M
I've been asked to consider whether we can use
mySQL for non-critical, but probably, enterprise-wide
databases [e.g. information stores].
How good is the feedback on mySQL handling Queries,
Transactions, ConcurrentUserCounts and DatabaseSize ?
Hemant K Chitale
http://hkchital.tripod.com
--
Plea
I find these lists pretty useful
[EMAIL PROTECTED] (For Apps DBA)
[EMAIL PROTECTED] (Covers functional aspects)
Regards
Naveen
-Original Message-
Sent: Tuesday, March 18, 2003 12:34 PM
To: Multiple recipients of list ORACLE-L
Hi all,
Can any one tell about the Oracle Applicat
Scott,
1. Contact the Oracle Sales rep. that sold Oracle product to the company.
Usually, he would have the details on whether there is a free support
available (generally during the first three months). Also, he could
coordinate with Oracle support to get a CSI #.
2. If the sales rep says you d
Hi,
Or may be because IBB is in the queue, that why it seems like not working.
Just my speculation
Sinardy
-Original Message-
Sent: 18 March 2003 17:09
To: Multiple recipients of list ORACLE-L
Inband breaks are (were) not supported by all protocols and not all
implementations of th
Inband breaks are (were) not supported by all protocols and not all
implementations of the same protocol on each platform (especially in the
early days of SQL*Net). It was clear to the developers that OBB was the most
optimal way of implementing break handling but not every platform did suppor
hi,
When I generate SQL report in Unix OS, while printing it skips a
page each time. How can i overcome that.
Thanx,
Sudhakar
___
Odomos - the only mosquito protection outside 4 walls -
Click here to know more!
http://r.rediff
85 matches
Mail list logo