Hi,As per your statement and the volume of transaction u have mentioned, I feel the db
which I tuned is peanuts when compared to yours. But it was the requirement of the
customer, I did what the customer wanted, that's it buddy.
Regards
venkat
--
On Mon, 13 Aug 2001 07:15:37
dgoulet
and very nice they are too.
Great book by the way.
Lee
-Original Message-
Sent: 13 August 2001 21:06
To: Multiple recipients of list ORACLE-L
And if it does confuse you, my book has
a couple of pretty pictures in it that might
help.
Jonathan Lewis
Seminars on getting the best
Title: RE: dropping a database link
I remember raising a TAR on this issue about 5 years ago and the upshot was that it was a known oddity and I should raise an enhancement request.
I am sure I did raise such a request but never heard anything more about it.
Regards
John
-Original
Hi gurus,
Recently, I have forgotten to backup one of rollback segment file
(rbs02.dbf).
When I want to restore..the db can not startup normally.
Anyone can give me advise..
Thanks in advance.
Warm regards,
Hermanto
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
Hi,
within the last 2 years, ... unfortunately none. Since I'm working at
the customer's site, I haven't had any training for the last 2 years. It
works more like: Me: What about class XYZ, KeyAccountManager: Do you
really need this ?, Me:Yes, because of .. blah blah, KeyAccDamager:
Ok. We'll
Hi everyone,
Can anyone let me know how I can access a function written as a COM
component and hosted in a dll from Forms6i?
Im able to access global functions in a dll through the ORA_FFI package but
the same is not able to recognise a COM component. If anyone can help me
out, kindly do.
Thanks
Hi all,
i've changed the log_buffer
parameter in my init file to a little higher value( say from 32768 to 40960) and
bounced my DB but sga shows the redo buffer to 73728 (no change in pre
value)
while looking into v$sgastat,
it says log_buffers = 65536 (still no change in pre value)
why
Hi ,
Your problem should be more specific.
here I am giving 2 solutions. Pl. choose whichever is applicable.
I.
1. comment the rollback segment in initsid.ora file.
2. connect internal
3. startup mount
4. Create rollback segment rbs02 with datafile rbs02.dbf(same as your
earlier file)
5.
Title: Message
Sharma:
Some of this extra memory is taken up with the
redo log guard pages. Guard pages are one memory protection unit in size and are
there to prevent Oracle software bugs or hackers from corrupting the log
buffer. Another portion of the
memory results from a minimum size
I have a server with iAS 1.0.2.2. installed in a separate home from an
already existing 8.1.7 database.
When I open up a browser and try to run the example form, the browser sits
idle and finally gives up. It doesn't even download JInitiator.
I have the right port, and the listeners are up.
UNCUT ORACLE-L
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tatireddy, Shrinivas (MED, Keane)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
Hi All,
I want to download a patch
725440 to avoid the error APP-22067 in Oracle Applications 10.7SC.
This patch information I got it in metalink docid
1070670.6.
Can any oneexplain how to download this
patch ?
Thanks
rukmini
I've heard of spare time.
-Original Message-
Sent: Tuesday, August 14, 2001 3:56 AM
To: Multiple recipients of list ORACLE-L
Hi,
within the last 2 years, ... unfortunately none. Since I'm working at
the customer's site, I haven't had any training for the last 2 years. It
works more
that's called subcontracting... and then to be fair, you'd have to take on
the expense of all your benefits -- 401k, medical, Social Security etc.
From: Jonathan Gennick [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re[2]: OT
1) Log into MetaLink
2) Click on the patch button on the left
3) Click on Application Patches
4) Enter your patch number in the patch number field
5) Pick your Platform
6) Click on submit
7) Click download
-Original Message-
Sent: Tuesday, August 14, 2001 8:12 AM
To: Multiple recipients
Rukmini:
1. Go to MetaLink
2. Go the Patches section (link on the left-hand bar)
3. Click on Click here for patches release after February 19, 2001 and for all
Application patches
4. Enter your patch number (725440) in the Patch Number field and click Submit at
the bottom of the page.
5.
time: here's a trick I learned from my other vocation, writing :)
I used to think that unless I had a block of time, it wasn't worth sitting
down to write. Then I realized that even if I wrote only a paragraph, that
was one less I had to write.
So read a page, or two. You don't have to read
Will the optimizer (CBO) ever use more than one index
in the access path for a table in a query? I have
never seen this behavior and have always been curious.
__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo!
Hermanto,
some more information would be helpful -- why are you restoring? are you
restoring from a cold or hot backup?
if it was from a cold backup, you can comment out the rollback_segments
parameter in the init.ora and start the database. Then I would drop the
rollback tablespace and
Is anyone using any of the folowing Oracle parameters? Are there any
problems associated with using them?
07_DICTIONARY_ACCESSIBILITY
DBLINK_ENCRYPT_LOGIN
ORA_ENCRYPT_LOGIN
Ron Smith
Database Administrator
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Chris,
Read-only and updatable snapshots/materialized views
are available with the Standard Edition starting with
8.1.5; SE can also be used for the master site for
snapshots/MV's. EE is required only for multi-master
replication and the data warehousing features of MV's
(e.g. summary
I would. It is one of the best books to have.
- Kirti Deshpande
-Original Message-
From: Jared Still [SMTP:[EMAIL PROTECTED]]
Sent: Monday, August 13, 2001 11:25 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: RAID or NOT to RAID? What's the diff???
And a
Mary,
It's a known bug introduced with the 8.1.6.3 patchset.
Bug 1577067 ORA-379 WITH UPDATE, AND-EQUAL
ROW-SOURCE
I would recommend contacting support to see if there
is a PSE (patchset exception) for your platform (quite
likely since you're on Solaris) or upgrading to 8.1.7
as it's been fixed
Title: RE: RAID or NOT to RAID? What's the diff???
I took Jonathan's book on holiday (sad person that I am). I read about 150 pages but I was frustrated because there were ideas I came across that I wanted to try especially re calculations on some of the indexing tips he suggested.
But I
Fyi I am downloading Developer6i Release 2 now, to open the test.fmb file
that comes with iAS 1.0.2.2..
Perhaps once I see what the Form expects, I will know what to enter in the
runform.htm fields to invoke the file properly.
Once I managed to invoke the report demo, I plugged in its variables
Of course first you need some royalties!!
LOL
Rachel
Carmichael To: Multiple
first thing is you should have MORE than one copy of the control file
mirrored on different drives.
you then copy one of the good ones to the other destination(s).
if you lost ALL of them, then breakout the oracle docs about
catastrophic loss of all controlfiles.
joe
Saurabh Sharma wrote:
You 'forgot' to backup a file?
How are you taking backups?
If a manual process. you should automate this
before you forget to backup the SYSTEM tablespace.
Jared
On Tuesday 14 August 2001 01:35, Hermanto P wrote:
Hi gurus,
Recently, I have forgotten to backup one of rollback segment file
Hi all
We are running Oracle 8.1.6. and OAS 4.0.8.2 on Solaris 2.7
We access the database from a web browser, using the pl/sql cartridge.
My question is how to identify who is running what package..
In instance manager we get a session id, status, username (application
user) and for program
$35
From: Thater, William [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: OT -- training
Date: Tue, 14 Aug 2001 05:00:24 -0800
Rachel Carmichael wrote:
On the other hand, I can take the day off for the NY Users Group
Check with your tax advisor again or get a new tax advisor. I don't
remember the exact details but you MUST show some tax-able profit for a
certain number of years out of every so many years (eg, 1 year out of the
last 4 - I'm not sure that those are the right numbers) or the IRS will
decide
The unkindest uncut of all - the Dedican uncut.
LOL
Bowes,
Chris To: Multiple
Can anyone tell me if it is possible to specify a pathname using NT to a
file with SQL*Plus spool command if the pathname contains a space. For
example if I want to spool output of a SQL*Plus session to
t:\oracle\output\system check\free_space.log can this be done. I've tried
enclosing the
Hermanto
Rollback segment data files are *needed* for recovery. Rollback segments are the key component for consistent media/instance recovery. If you lose any of the rollback segment files and if any extents from that datafile are needed then the database can not do the recovery consistently
Sean:
Use the shorter 8.3 directory name. You can get it with the dir /x command. Then you
could do something like:
t:\oracle\output\system~1\free_space.log
Jon Walthour
From: O'Neill, Sean [EMAIL PROTECTED]
Date: 2001/08/14 Tue AM 10:15:23 EDT
To: Multiple recipients of list ORACLE-L
Patrice,
I can't help you all that much since we're using IIS and Oracle 8.0.6.
However, regarding the part about not dowloading JInitiator, I had the same
problem.
To solve it I edited the file $O_H\jinit\us\jinit_download.htm.
(They say you need this file when using Netscape, however it
Rachel says:
Oracle has to have at least ONE controlfile to open. If you have more than
one, and deleted only one, you can edit the init.ora and change the
controlfiles parameter to remove the one that is missing.
OR, if you have another control file available, simply copy and rename it to
Yes. It can. In fact, AND_EQUAL hint can be specified to use multiple indexes and merge them for single table access path..
From tuning guide:
AND_EQUAL
This hint explicitly chooses an execution plan that uses an access path that merges the scans on several single column indexes.
Thanks
Hi
Recovery process will read from undo$ table to identify all the rollback segments that were online. Even if you comment out the rollback segments from the init file, still Oracle knows what rollback segments were online from the undo$ table. If i remember correctly, after reading the undo$
Title: OT: RE: UNCUT ORACLE-L The Motion Picture
UNCUT ORACLE-L
Coming to theaters near you. Oracle-L, the UNCUT version is rated NC-17.
Directed by Bruce.
Produced by Jared Still.
Starring:
Lisa Koivu.
Hi DBA's,
I know this question was asked some time ago.
Although I tried the recommended solution, it did not work for me.
I'll paste my scripts. Hopefully, someone can point out my error.
First the background:
I want to run this scripts from a remote client machine which has the Oracle
DBA
Hi list:
I've been analyzing an instance's performance for
some time. I found a lot of enqueue and a lot of
buffer busy waits.
Tracing the instance's sessions for some time I found
that enqueue waits are mostly because of FK not being
indexed. This of course generated shared locks (level
4)
Hi All,
We have data warehouse which uses arround 34 GB of
temporary tablespace. The datafiles for this are
tempfiles and the tablespace is LMT.
We use EMC storage.
The tempfiles are on two file systems which inturn are
mirrored and striped across three 8 GB disks.
We are seeing heavy IO on
Apart from the special case of bitmap indexes
which are almost invariable combined through
AND and OR, it is possible for Oracle to use
other access paths that combine multiple
indexes.
The AND-EQUAL path still exists, but with CBO
the statistics have to be pretty finely balanced for
it to be
ROFL
But, reallywhy do I have to be Joe Pesci? I really
must cut down on my delivery speed...sigh.
Oh well...reminds me of my first shamanic journey to
the middle worldturns out my power animal was a
squirrel.
A friggin' squirrel.
LoL
Ah well, I am an oracle dba...I
Hermanto,
That depends on whether your using public or private rollback segments.
Personally I prefer private just for this reason. So, assuming your using
private rollback segments:
1) shutdown your DB.
2) comment our the ROLLBACK_SEGS parameter in INIT.ora
3) startup mount the DB
4)
Hi Saurabh,
After deleting the original control file , did you replace it with the newly created copy with same name path etc.?
HTH.
Jyoti
From: "Saurabh Sharma" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: lost
Title: OT: RE: UNCUT ORACLE-L The Motion Picture
btw,
Can I meet this "rouge" college intern before Lisa machetes
her?
EG
I want
to justify the NC-17 rating.
-
Hannibal
-Original Message-From: Bowes, Chris
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 14, 2001 10:47
Have you seen Momento? Really cool film. Better mind
games than oracle. A little coarse for me, but really cool
anyway, two thumbs up.
On Tue, Aug 14, 2001 at 07:10:22AM -0800, [EMAIL PROTECTED] wrote:
The unkindest uncut of all - the Dedican uncut.
LOL
Ok, I have to ask.
If you didn't have any idea how to recover from a missing
controlfile, why did you remove it?
All you need to do is copy one of the other control files
to the location of the one you removed.
Jared
On Tuesday 14 August 2001 05:50, Saurabh Sharma wrote:
hi all,
i was
Create a database link between the 2 databases or
export and import the table.
For syntax, I usually check in the doc.
--- Mark Liggayu [EMAIL PROTECTED]
a écrit : Hi Gurus,
Can anyone tell me how to extract information from a
table in another
database. Please provide the syntax for it.
http://www.theregister.co.uk/content/53/21003.html
http://www.theregister.co.uk/content/53/21003.html
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics
FYI, I found this on www.arstechnica.com: http://www.arstechnica.com:
H1B visas and the slowing economy Posted 08/13/2001 - 8:55pm EDT [Discussion
http://arstechnica.infopop.net/OpenTopic/page?a=tpcs=50009562f=174096756;
m=5280992842 ]
Just over a year ago, a poll
On Mon, Aug 13, 2001 at 11:45:20PM -0800, Robertson Lee - lerobe wrote:
and very nice they are too.
Great book by the way.
Hmmm, so what would folks consider their essential Oracle books? maybe your
personal top 2 or 3?
-s
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Hi Gurus,
Can anyone tell me how to extract information from a table in another
database. Please provide the syntax for it.
Thanks,
Mark
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Liggayu
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
How can I resolve this error?
Error: ORA-06502: PL/SQL: numeric or value error: character string buffer
too small
ATT Latin America
Alex Tomita Koga
Information Technology (IT)
e-mail: [EMAIL PROTECTED]
phone: (511) 610 (2619)
--
Please see the official ORACLE-L FAQ:
Title: I admit this is dumb. NT/W2K Services?
I'm playing with Oracle on w2k out of sheer boredom. So now I'm forced to learn a little bit about w2k.
I was looking at oradim and it has starttype and shuttype with options srvc and inst. OK, I understand the instance part. But what on earth
Riyaj,
Rollback segments are needed for recovery? I think your confused with the
online redo logs. When a DB shuts down the rollback segments are emptied out
either because the transactions have been rolled back or committed. Once you
start the recovery process the rollback segments are
Add the foreign host name to your local /etc/hosts file.
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
Naik, Sandesh
Pretty amazing actually. I won't feel so bad about missing the cruise this
year :-( If I get get to attend this one.
Jay Miller
-Original Message-
Sent: Monday, August 13, 2001 10:21 PM
To: Multiple recipients of list ORACLE-L
On the other hand, I can take the day off for the NY
I just ordered it on Book Pool, never read his book,
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 OCP MCSE MCP A+ RAPTOR CNA
Oracle DBA
Phone: (978) 322-5744
Fax:(707)
Ron,
Hp_UX 11.0.32 Database 8.1.6.2
We are running with following settings for couple of months without having
any problem. No 1. parameter default is TRUE...
1- O7_DICTIONARY_ACCESSIBILITYTRUE
2- dblink_encrypt_login FALSE
3- ORA_ENCRYPT_LOGIN -Not found in
Dear List,
I have 8.0.5.2.1(32bit) database on HP-UX 11.0 server.
I have a database link connecting to other database. I get following error
while trying to access objects thorough db link ( db link goes to 8.1.6.2.0
(64bit) database on HP-UX 11.0
ORA-12545: Connect failed because target
Ok i know i'm doing something wrong here in working with
external proc listener as i can even get the stupid demo to work
right.
here is my listener.ora
LISTENER_EXTPROC= (ADDRESS = (PROTOCOL =
IPC) (KEY = extproc))
SID_LIST_LISTENER_EXTPROC (SID_LIST =
(SID_DESC
=
(SID_NAME =
look up create database link.
there you'll find the syntax
Reading is a wonderful thing.
joe
[EMAIL PROTECTED] 08/14/01 12:26PM
Hi Gurus,Can anyone tell me how to extract information
from a table in anotherdatabase. Please provide the syntax for
it.Thanks,Mark-- Please see the official
What about mount point on same controller? Split them on different
controller if not ? What is the maximum usage of your TEMP tablespace ? and
size of datafiles...? Try to reduce size of your temp tablespace as it looks
very large
Better solution is
Datfiles of 501MB each split on
Actually I talked to a friend who is pretty knowlegable about this stuff and
he says that what it will really come down to is intent. The IRS is not
going to call your business a hobby if it is in fact unquestionably a
business, even if it has lost money for a period of years. - E
-Original
Title: RE: OT: RE: UNCUT ORACLE-L The Motion Picture
OK, ok. You can be Keanu Reeves or David Duchovny. If you are going to be my sidekick you better be easy on the eyes !
Believe it or not a friend of mine cast me in his movie being shot next month - I am the bitchy bride who catches her
Koivu, Lisa wrote:
OK, ok. You can be Keanu Reeves or David Duchovny. If you are going
to be my sidekick you better be easy on the eyes !
can i have the jackie chan part? i'm good at humor. gotta have some
comic relief. and believe me, i look the comic relief part.;-)
--
Bill Shrek
Title: RE: OT: RE: UNCUT ORACLE-L The Motion Picture
Thanks!...butcan I be John Cusack?
I like
the whole hangdog, embittered but mostly confused post relationship luckless
ne'er do well thing.
Yes!
Chris should get an award!
Especially if he gets me that "rouge intern".
Patrice,
Thanks for the message, we all over here had one heck of a good laugh. It
just shows that MS is still running around with there heads in the ground and
phony sales figures. Bet you did not know that every one who buys Windows
Server gets a SQL*server license right along with it.
Title: I admit this is dumb. NT/W2K Services?
I am
sure you have already found the windows 2000 server on-line help
pages http://www.microsoft.com/windows2000/en/server/help/
A
service is just what the generic info says. They are processes on Windows
that run in the background handling
Funny how they never mentioned HP-UX as Oracle no longer plays nicely with
Sun.
Also, M$ obviously avoided the hard questions, although I do see SQL Server
taking a chomp out of Oracle. You just can't charge $1,000,000 for a
workgroup solution, people just don't have the money. Nor do they
Title: OT: RE: UNCUT ORACLE-L The Motion Picture
That
was too funny and too creative!:)
KK
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, RossSent:
Tuesday, August 14, 2001 12:45 PMTo: Multiple recipients of list
ORACLE-LSubject: RE:
Well there must be something to the statement, back in v7
days, i did a shtdown abort, when i had a lrage RBS online(and not in the
init.ora file), well when i tried to bring the db backup, it refused until i put
the rbs in the init.ora file and oracle could then do recovery, short of an
Hi All,
I am facing a very different problem.
I am using Oracle as a XA Resouce Manager for Encina.
The Encina applications built using Oracle 8.0.6 are working fine. When we moved
the Oracle version to
Oracle 8.0.6.3 the applications are not able to connect to the database.
It gives the
Title: Personal Top 3 Oracle titles
Guy Harrison's High Performance SQL Tuning Book
Steven Feuernstein's PL/SQL books (O'Reilly)
Both of these books taught me a lot of what I know. I read Harrison's book cover to cover.
Don't forget the Oracle Documentation... !
I haven't purchased a
JOE TESTA wrote:
Bill, besides the part, you know how to kick people's butts :) Joe
who? me?;-) i don't do that for a living anymore, but
today i'd like to delete some users. we have 25% less people, 50%
more work and they want it done 100% faster.;-)
--
Bill Shrek Thater
Title: RE: Re[2]: How can I get my DB back if I lost one of my rollback
Hi Dick,
I see your point. What about when the db does something similar to a shutdown abort? Then you do need your rollback segments to perform a full recovery.
LK
-Original Message-
From: [EMAIL
Bill, besides the part, you know how to kick people's butts
:)
Joe
[EMAIL PROTECTED] 08/14/01 01:31PM
"Koivu, Lisa" wrote: OK, ok. You can be
Keanu Reeves or David Duchovny. If you are going to be my sidekick
you better be easy on the eyes !can i have the jackie chan part?
i'm good at
I haven't worked on Windows2000, but if it's like NT, you have two things to
worry about when starting Oracle in the Windows environment:
The background service has to be running, to provide a context.
The instance has to be started otherwise it is in shutdown mode.
On NT 4, there is an NT
already did that , doesn't work, funny thing is I can tnsping that foreign
database but doesn't work through db link.
Thanks
Sandesh
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 14, 2001 1:32 PM
To: Multiple recipients of list ORACLE-L
Add the foreign host name
OH man, THANK YOU for the giggles I've needed these.
Rachel
From: Bowes, Chris [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: OT: RE: UNCUT ORACLE-L The Motion Picture
Date: Tue, 14 Aug 2001 06:47:22 -0800
UNCUT ORACLE-L
Joe,
Extproc's are a pain until you get them figured out the first time. Here is
a copy of the listener file we use on one of the instances where it does work:
SQLNET.AUTHENTICATION_SERVICES = (NONE)
LOGGING_LISTENER = OFF
USE_PLUG_AND_PLAY_LISTENER = OFF
USE_CKPFILE_LISTENER = OFF
Joe;
Shouldn't the KEY match
the SID_NAME ???
EXTERNAL_PROCEDURE_LISTENER=
(ADDRESS_LIST=
(ADDRESS=
(PROTOCOL=IPC)
(KEY=extproc)==
)
)SID_LIST_EXTERNAL_PROCEDURE_LISTENER=
(SID_LIST= (SID_DESC=
(SID_NAME=extproc)===
The same statement I use for Unix, I will use for SQL Server.
Give me $40,000 and I will build an NT box, take $40,000 and build a unix
(Solaris, HP-UX, AIX type) and see who wins.
Same thing works for SQL Server and Oracle.
Granted $40,000 is a small budget, but there are a lot of people
Title: Personal Top 3 Oracle titles
Lisa;
Over the past 4 years the two best books I have found for work on Oracle are the
Steven Feuernstein's books (O'Reilly)
Oracle
PL/SQL Programming
Oracle
Build-in Packages
These
two books have taught me so much on the programming side of the
do I have to limit it to 3? besides, the list varies with the sort of work
I happen to be doing but...
(please, no offence to anyone I've left out)
Performance Tuning 101
Practical Oracle8i
Oracle8i DBA Handbook
there are others... but you said 3
From: Steve Armijo [EMAIL PROTECTED]
Yep, I got lucky, and called on a lot of people I know.
For those of you lost in this semi-private conversation, the NYOUG meeting
on September 12th (and yes, non-members are welcome) is being called the
Literary Lights meeting.
presenters include: our own Gaja Krishna Vaidyanatha and Ari
Lisa,
I believe that is why using shutdown abort is not truly endorsed by
Oracle, except as a last resort. What I've noticed on the list is the desire by
some to over use this method of shutting down the DB. Now I will admit that
shutdown normal is a real pain in the back side since every
he's not bad on the eyes in and of himself... think Tim Everett Scott
From: Koivu, Lisa [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: OT: RE: UNCUT ORACLE-L The Motion Picture
Date: Tue, 14 Aug 2001 09:11:45 -0800
OK, ok.
no, first you need to write a book, then you PRAY for royalties
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: OT -- training
Date: Tue, 14 Aug 2001 06:47:21 -0800
Of course first you need some royalties!!
LOL
thanks a bunch that was it. and to think i trusted the
oracle docs for an example, doh, i should know better.
someone smack me, i'm sure there are enough of you out there
who'd like to :)
joe
[EMAIL PROTECTED] 08/14/01 02:27PM
Joe;
Shouldn't the KEY match
the SID_NAME ???
last I heard it was 1 year in 5
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: OT -- training
Date: Tue, 14 Aug 2001 06:41:02 -0800
Check with your tax advisor again or get a new tax advisor. I don't
remember the
Not my speciality - but
a) is it possible the PROGRAM=EXTRPROC needs to
have extproc in lower case ?
b) Do you have an sqlnet.ora with a
names.default_domain=something
in which case your
extproc_connection_data=
should be
extproc_connection_data.something=
I don't even have the excuse of it being too early and before I've had
coffee... especially since I've done the copy route a number of times.
sigh. thanks Tom!
From: Mercadante, Thomas F [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL
We installed 8.17 on the production machine. We have 2 different
oracle_home, 8.1.6 and 8.1.7. After runinstaller, it comes the error
message, cannot find file on /oracle/jre. I checked the whole jre bin
directory is created on /tmp dir.
I set all the environment variable, (except JRE_HOME)
but
Anita - I checked 112591.1 and also filed an iTAR to confirm with Oracle
- there is no materialized view functionality for SE.
Chris - Alas, transportable tablespaces are not available for SE either.
I'm still looking for suggestions. The tables need to be
read-consistent down to the second.
Before I buy a book I always check Amazon.com's reader
reviews. They can be very helpful.
Ken Janusz, CPIM
Guy Harrison's High Performance SQL Tuning Book
Steven Feuernstein's PL/SQL books (O'Reilly)
Both of these books taught me a lot of what I know. I read Harrison's book
cover to
Title: NT/W2K Services - Thanks
Patrice, thank you so much for sending this to me (and the list). This explains a lot.
Also, thanks to Kevin Lange.
Now I need to get over my initial nauseous feeling from running an oracle database on Windows.
LK
-Original Message-
From:
1 - 100 of 171 matches
Mail list logo