[EMAIL PROTECTED] wrote:
>
> Dear List,
>
> First, a little background. A coworker and I have been charged with
> developing and implementing a 'short term' 'Reporting Solution'.
>
> Glossary:
>
> short term: low cast, fast to implement, throw it away late next year
>
> Reporting Solution:
Stephen,
This is the *same* restaurant (just across the street from Moscone in fact)
that we met last OOW, again reserved by Gerardo. I am sure that Gaja will
find some 'veggie' stuff, as he did the previous time. From the list below,
it looks like we will have the highest level of Oracle talent i
I could give you a great little list, but that would kind of defeat my job purposes
right now ;) If you know that OEM "can be used" why not install and try it to get a
feel for what Oracle themselves think is useful in an Oracle monitoring tool? Always
seems to be a good start..
Ah go on, I'll
Hi all
i am trying to execuate one procedure which upadte the table containing 29443 records.
After 2 hours going in loop, procedure returns following error:
SQL> exec test
BEGIN test; END;
*
ERROR at line 1:
ORA-01562: failed to extend rollback segment number 2
ORA-01628: max # extents (249) r
No you won't get valid output. You need to cut and paste so that each
session has a file for all its statements.
Anjo.
-Original Message-
Jalsingh
Sent: Friday, November 01, 2002 7:59 AM
To: Multiple recipients of list ORACLE-L
Hi
We are running Baan erp application. Baan opens multil
3 options
1. if possible , put a commit in your procedure to reduce load on rollback
segs
2. ask your dba to increase size of rollback segments. Since rollback
segment allocation is random, u may have to drop the smaller rbs segs and
create new larger segs
3. increase the maxextents of existing rb
Hi
I have installed oracle server 8.1.6 on windows 2000 system. It is working
fine.
After this, I installed oracle client 8.1.6 on windows 2000 system. But
domain of both
oracle server and client machines are diffrent. I used complete service
name with domain name
and oracle is accessible from wi
ORACLE -L NO MAIL
Hi,
I've just been asked if Oracle has an API which allows you to query the
progress of a query, say, as a percentage of the whole time taken. I'm
guessing that it would be an extremely complex algorithm to implement, if
at all possible. Does anyone know if something like this exists?
Thanks,
SET ORACLE-L NOMAIL
dbms_lock.sleep is notoriously inaccurate for large
time scales... presumably it just counts some sort of
ticks and makes assumptions from there.
If you want to sleep for 6 hours, you'd be better
issuing 6x12x5min sleeps
hth
connor
--- Jared Still <[EMAIL PROTECTED]> wrote: >
> OK, so my code
BCHR ???
Anjo ;-)
-Original Message-
Sent: Friday, November 01, 2002 10:34 AM
To: Multiple recipients of list ORACLE-L
I could give you a great little list, but that would kind of defeat my
job purposes right now ;) If you know that OEM "can be used" why not
install and try it to get a f
HELP
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]Sent: Friday, November 01, 2002 5:58
AMTo: Multiple recipients of list ORACLE-LSubject:
ORACLE -L NO
MAIL
Not very complex at all. Oracle leaves all the complexity to you...
Check documentation for the V$SESSION_LONGOPS view and the
DBMS_APPLICATION_INFO packaged procedures/functions used to populate it...
Oracle has gradually been "instrumenting" some of its operations to report
to V$SESSION_LONGOP
Title: RE: dbms_lock.sleep irregularities
Jared,
remove the to_date ... that is causing the problem ...
=== DOESN'T WORK =
oraclei@pallas-ACPT2> sys
SQL*Plus: Release 9.2.0.1.0 - Production on Fri Nov 1 07:51:00 2002
Copyright (c) 1982, 2002, Or
What about giving them STATSPACK and saving
yourself some time, money, and trouble?
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Friday, November 01, 2002 12:23
AM
Subject: Database Monitoring tool
Dear All, We a
On Fri, Nov 01, 2002 at 03:58:27AM -0800, [EMAIL PROTECTED] wrote:
> ORACLE -L NO MAIL
--
-
ListGuru GENERAL Command HELP
-
This help file contains basic informat
On Fri, 1 Nov 2002, Maria Quinn wrote:
> I've just been asked if Oracle has an API which allows you to query
> the progress of a query, say, as a percentage of the whole time
> taken.
It sure does. Look into v$session_longops. It gets better and better
with every release.
--
Jeremiah Wilton
ht
h
quick and easy...
Jared-with SAP, would it be possible to build a "meta data" layer that is
typically used by other tools? For example-Crystal (yuk), Business Objects,
Brio, etc,etc???
Maybe a combination of ideas Use one of the above tools that requires a
Meta layer, have the tool ge
Title: RE: Database Monitoring tool
Anjo ...
you need to buy some (specific) books on Oracle Tuning to understand BCHR ... 8:>
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expre
On Thu, 31 Oct 2002, [EMAIL PROTECTED] wrote:
> Reboot and open a TAR.
I would preserve the evidence as long as is practical, and open a
ticket with Sun. There should not be a sustained condition in Solaris
during which a process is unkillable with SIGKILL. If you open a TAR,
this is probably w
- Forwarded message from [EMAIL PROTECTED] -
Date: Thu, 31 Oct 2002 16:58:08 -0800 (PST)
To: [EMAIL PROTECTED]
Oracle Security Product Management Issues Security Alert #46
This e-mail contains a critical, technical alert which is being sent as a service to
all Oracle MetaLink users.
Or
Come on now Mark. Get up on your soapbox & hand us the sales pitch. *-)
Dick Goulet
Reply Separator
Author: "Mark Leith" <[EMAIL PROTECTED]>
Date: 11/1/2002 1:33 AM
I could give you a great little list, but that would kind of defeat my job
purposes
ROFL, I don't miss the 495 parking lot or the 1.5 hr LIRR commute. Now if I could
only get rid of these dayuum mosquitos :)
Gene
>>> [EMAIL PROTECTED] 10/31/02 03:28PM >>>
...the correct pronunciation is "lan GUY-lun"...
> Ya, that's it!
> (Peter still wanted to argue with me. Is Long Islan
B(uffer) C(ache) H(it) R(atio)
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, November 01, 2002 9:03 AM
To: Multiple recipients of list ORACLE-L
BCHR ???
Anjo ;-)
-Original Message-
Sent: Friday, November 01, 2002 10:34 AM
To: Multiple recipient
> -Original Message-
>
> when I try to "sync" the session hung (init will sync
> automatically therefore it hung too)
> I have to POWER OFF and POWER ON my SUN BOX to release the mount point
> My sun clustering fail to fail over because of this
>
> there is jargon in unix call zombie p
Its the classic three part story...
Part 1: 20 great friends meet for the dinner
Part 2: The bill arrrive
"I only had one piece of garlic bread!"
"You drank some of my wine!"
"I shared my burger with Joe over there!"
Part 3: 20 arch enemies storm out...
:-)
--- "Karniotis, Stephen"
Maybe throw in Brain v1.1
I've always find that useful, although my version is
getting a little obsolete.
Cheers
Connor
--- Tim Gorman <[EMAIL PROTECTED]> wrote: > What
about giving them STATSPACK and saving yourself
> some time, money, and trouble?
> - Original Message -
> From: [
heLP
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]Sent: Friday, November 01, 2002 5:58
AMTo: Multiple recipients of list ORACLE-LSubject:
SET ORACLE-L NOMAIL
Tim,
Do I remember you saying at one time that you were located in Minneapolis?
Jared Still will be in Minneapolis next week and some of us here in town
are planning a little get-together here one evening.
If it was indeed you that I was thinking of and you'd be interested in
getting together w
>From Oracle docs:
V$SESSION_LONGOPS
This view displays the status of various operations that run for longer than
6 seconds (in absolute time). These operations currently include many backup
and recovery functions, statistics gathering, and query execution, and more
operations are added for every
Ok, so You are an IDIOT!!
Reply Separator
Author: [EMAIL PROTECTED]
Date: 11/1/2002 3:58 AM
SET ORACLE-L NOMAIL
SET ORACLE-L
NOMAIL
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Netwo
Jared - there was a very similar project done here a few years back - and
yes it's still running even though the DW is starting to breathe ;-)
they implemented the intranet solution. reports go to text files on an NT
box, a DOS script picks them up, runs them thru a text-to-pdf on the cheap
tool,
F1
April Wells Oracle DBA Great spirits have always encountered violent
opposition from mediocre minds -- Albert Einstein
-Original Message-From: Farnsworth, Dave
[mailto:[EMAIL PROTECTED]]Sent: Friday, November 01,
2002 7:29 AMTo: Multiple recipients of list
ORACLE-LSubj
lol, I'm never one to do that Dick ;)
Although I do have a great tool for your Peoplesoft environment..
;P
-Original Message-
[EMAIL PROTECTED]
Sent: 01 November 2002 14:49
To: Multiple recipients of list ORACLE-L
Subject:Re:RE: Database Monitoring tool
Come on now Mark.
Title: RE: query progress meter
But ... you have to keep updating the data in v$session_longops ... using dbms_application_info to actually see it in the query.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at
Scott, you probably have an error in your parameters.
Try "startup pfile=/oracle/product/9.2.0/dbs/init_MYSID.ora".
That should work.
> -Original Message-
> From: Scott Stefick [mailto:sstefick@;harper.cc.il.us]
> Sent: Thursday, October 31, 2002 7:14 PM
> To: Multiple recipients of list O
No issues... Just define a strategy on how you want to implement things of
this nature.
We have multiple database servers running multiple versions of Oracle. We
have Enterprise servers running 7.3.4 thru 9.2 on the same box. But build a
plan/strategy.. and stick to it to remove the "emotions"
O
Whatever happened to the good old days when the corp picked up the tab? I am sure
conversation will lead to Oracle and if so, its business :). Just wish I were going,
my employer allows a hefty $12 for dinner.
>>> [EMAIL PROTECTED] 11/01/02 08:48AM >>>
Its the classic three part story...
Par
Raj,
Actually, that isn't the problem. The to_date is unnecessary, but if
you examine my example you will see that the correct number of
seconds is calculated.
The actual problem is described at :
http://www.jlcomp.demon.co.uk/faq/sleep.html
Thanks to Waleed to locating that.
The short v
"Mercadante, Thomas F" wrote:
>
> B(uffer) C(ache) H(it) R(atio)
>
> Tom Mercadante
> Oracle Certified Professional
>
> -Original Message-
> Sent: Friday, November 01, 2002 9:03 AM
> To: Multiple recipients of list ORACLE-L
>
> BCHR ???
>
> Anjo ;-)
>
Tom,
Go and wash your mouth
On Fri, 1 Nov 2002, Jamadagni, Rajendra wrote:
> But ... you have to keep updating the data in v$session_longops ... using
> dbms_application_info to actually see it in the query.
No, you don't have to update anything if you are tracking table scans,
index builds, and all kinds of other stuff tha
I work on contract and as a consulting Oracle DBA. I've migrated several
companies from SQL Server because the block level locking did not scale to
Oracle. I never had anyone ask me if I could convert them from Oracle to
SQL Server.
- Original Message -
To: "Multiple recipients of list OR
Title: RE: dbms_lock.sleep irregularities
Jared,
I didn't know this one ...
Thanks
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect th
The only thing that comes close (I think) is the v$longops view.
Anjo.
-Original Message-
Quinn
Sent: Friday, November 01, 2002 1:49 PM
To: Multiple recipients of list ORACLE-L
Hi,
I've just been asked if Oracle has an API which allows you to query the
progress of a query, say, as a per
Stephane,
Yes, you have hit upon the crux of the problem. Generating
reports is easy, but managing the output is hard. I was hoping
to find that someone here had faced the same or similar problem
at some time. Doesn't look like it though.
The idea for using a table with a BFILE sounds like it
Jared,
My company went through a similar situation. We are running SAP 4.6B with
Oracle 8.1.7 on HPUX 11.0. Our solution was the same you propose. The report
scheduled in the background with the output going to a Unix file. The file
is moved to a web server by FTP. The user can then access the repo
Interesting bug, isn't it?
If you really needed to use dbms_lock.sleep, you would need
to write a wrapper that multiplies the oriiginal time by 0.976, then
breaks the time into chunks, say 100 second chunks, plus the
remainder, and calls dbms_lock.sleep for each chink.
There would be some overh
Eh eh eh, I put wait stats first!!
People still argue the point of this being a valid problem "indicator" anyway..
;)
-Original Message-
Kolk
Sent: 01 November 2002 14:03
To: Multiple recipients of list ORACLE-L
Subject:RE: Database Monitoring tool
BCHR ???
Anjo ;-)
--
Stephane,
B(ite) M(e)
or, in French:
Mordez-Moi
sincerely, and with all true feeling,
Tom
-Original Message-
Sent: Friday, November 01, 2002 12:19 PM
To: Multiple recipients of list ORACLE-L
"Mercadante, Thomas F" wrote:
>
> B(uffer) C(ache) H(it) R(atio)
>
> Tom Mercadante
>
Here is a working version of accusleep if anyone
is interested. I ran a test to sleep for about
65 minutes, and the result was within 1 second
of the target time.
08:56:25 rsysdevdb.radisys.com - jkstill@dv01 SQL> @accusleep
Procedure created.
08:56:28 rsysdevdb.radisys.com - jkstill@dv01 SQL
I have never been given a choice to use anything other than RAID 5. The
storage management group dictates what we get and the Server admin group and
DBA's have to live with it. (Large IT shop everything in its own silo).
Though it has not been the end of the world being on RAID 5, but then I was
Are you an idiot? Ruth
- Original Message -
From:
Farnsworth, Dave
To: Multiple recipients of list ORACLE-L
Sent: Friday, November 01, 2002 9:03
AM
Subject: RE:
heLP
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]Sent
Dave,
Not much work going on there? ;-)
Lewis Bishop
---
Barclays Enable - ISS -
E-NTRUST/Bexleyheath NT
Oracle Database Consultant
Watling Street, Bexleyheath, Kent,
DA6 7RR (Mail Van R)
Phone : 020 8298 3418
Mobile: 07950 380857
Email : [EMAIL PROTECTED]
"Enabling Co
Title: RE: creating a 9.2 database
I did this (create a template, exit and re-run, select
template, go to step 7 (last screen)). Nowhere did I see an
option to have the script to a file. Do you know which
step this is found in?
Matt Adams - GE Appliances - [EMAIL PROTECTED]
My compu
Therefore You have to find SPONSOR!
Gints Plivna,
Softex Latvia,
Tel. 7204520
Fax 7204260
http://www.softex.lv
-Original Message-
Sent: Friday, November 01, 2002 3:49 PM
To: Multiple recipients of list ORACLE-L
Its the classic three part story...
Part 1: 20 great friends meet for th
Title: RE: Get together at OOW
Not all the time. At the IOUG-A Live in Ananheim a few years
ago, we all met
at a resturant for dinner. We had just one bill, I collected the
cash from everyone and paid the bill. Everybody insisted that they
only gave me enough money to cover their portion of
I have some questions with reference cursors:
I'm using Oracle 8.1.7 (on windows 2000:( )now but
would be interested in both 8.1.7 and Oracle 9i.
1>Is is possible to return a ref cursor to a Java
program (using JDBC API)?
2> How efficient is it as opposed to using
preparestatement?
3> Are there an
What I found happening with monitoring tools that use agents is that these
do not connect to the database in the same way that the applications
connect; and there were times when the agent thought everything was A-OK
when they weren't. So I wrote a ksh script which has grown to 1402 lines.
Withou
Dennis,
I had mentioned the licensing. But, it is a separate topic. They wanted to
know from a technical perspective could it be done.
I agree that one should stick with vendor certified systems. I support
PeopleSoft on Oracle so I am very fussy about what versions we are on.
As for this applic
Title: RE: Get together at OOW
If it
is a get together for dinner after IOUG live in April in Orlando I would even
pick up the bill for a couple of names on this list. (I get to choose the
names).
Hehe
-Original Message-From: Adams, Matthew (GECP, MABG,
088130) [mailto:[EMAIL
Hmmm, ARE YOU AN IDIOT?
On Friday 01 November 2002 14:29, you wrote:
> HELP
>
> -Original Message-
> Sent: Friday, November 01, 2002 5:58 AM
> To: Multiple recipients of list ORACLE-L
> Subject:
>
>
>
> ORACLE -L NO MAIL
--
Pruner Jan
[EMAIL PROTECTED]
http://jan.
I'm just doing a sanity test on my befuddled brain.
I have a schema owner called JOE which owns a bunch of tables.
While logged into the instance as JOE, he does the following -
SQL> GRANT SELECT ON BASE_TABLE TO STD_ROLE;
While logged into the instances as SYS, I do the following -
SQL> GRANT ST
Hey Gang;
Anyone here familliar with an "End Of Communication Channel" error every
time I try and Build a database ??
I am trying to build an 8.1.7.0 database on a Sun Sparc 20 running Solaris
9.
I have a feeling it might be settings on the box itself, but thought I would
ask the list just in c
Also, if you do move to a new tablespace please consider moving to uniform
extents which will remove any need to defragment in the future (I assume
you're doing it because of wasted space in the tablespace and not because of
the now-discredited notion that it's bad to have many extents for a
partic
I worked on a system that was being developed on Raid-5. We didn't
experience any I/O performance issues until I converted the singleton
inserts/updates to array inserts/updates. Then we bottlenecked on the redo
logs. We moved those off to a Raid 0+1 and the I/O bottleneck went away. At
least until
Tom,
Much better to say Fmlp - (F)iche-(m)oi (l)e (p)aye! Or better yet say that
someone's liver is going bad (the French have a great love for the health of
their liver). To get really down and dirty, say something about essences
(espece de chameaux, etc.).
Now, as far as Access, I have yet to f
Test
failed. Try again. What exactly are you testing?
Yes,
it's true, the internet does exist.
-Original Message-From: Natalia Lorena Laracca
[mailto:[EMAIL PROTECTED]]Sent: Friday, November 01, 2002 12:00
PMTo: Multiple recipients of list ORACLE-LSubject:
Test
Do please count me in too. I believe Marlene Theriault will be
there as well, so we might ask if she would be interested.
RF
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!
Londo Mollari: Ah,
I am part-time DBA for an Oracle system that for reasons
beyond our control is frozen at 7.3.4, at least for the
immediate future. I am having some problems and I think
I know how to correct them but I am asking the old-timers
to dust off their brains to tell me if my proposals are
O.K.
It starte
Privileges received via a role cannot be used to create stored objects
(e.g., views, packages). JOE will have to grant SELECT on the table to
SUE WITH GRANT OPTION in order for her to create the view.
PB
--- [EMAIL PROTECTED] wrote:
>
> I'm just doing a sanity test on my befuddled brain.
>
> I
Very, very lucky.
I've been trying to get permission to move just my temporary tablespace to
locally managed for months. My boss' boss refuses to give the okay until
after our standby database is moved to a new location (if anyone can explain
why those two things are related in any way I'd be ov
Title: RE: creating a 9.2 database
There are
two check boxes at the end of the DBCA steps. One is to create a template, the other is to create scripts. The tricky thing about the 9i DBCA is
that the options are different if you choose New Database rather than the other
choices. I’ve che
Jared,
Have you looked at how Apps (yes, from our favorite vendor) provides reading
of previously created report using the FNDFS listener? The
APPLSYS.FND_CONCURRENT_REQUESTS table maintains the details of the report,
and the FNFS listener pulls that out of the APPLCSF/out directory.
John Kanagar
Title: RE: VIEWS/ROLES/PRIVS
Sue also needs the CREATE ANY VIEW system privilege.
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
I'm just doing a sanity test on my b
[EMAIL PROTECTED] wrote:
>
> I'm just doing a sanity test on my befuddled brain.
>
> I have a schema owner called JOE which owns a bunch of tables.
> While logged into the instance as JOE, he does the following -
> SQL> GRANT SELECT ON BASE_TABLE TO STD_ROLE;
> While logged into the instances as
--So my questions are:
-- 1) Is there any reason to keep all the tablespaces on one
-- mount point?
-- 2) I know about keeping table data and indexes in different
-- tablespaces but can they also be on different mount points?
-- 3) Any reason for not putting my 1 large temp-table into it
Forget this. Found the error.
WARNING: EINVAL creating segment of size 0x0a086000
fix shm parameters in /etc/system or equivalent
-Original Message-
Sent: Friday, November 01, 2002 11:34 AM
To: Multiple recipients of list ORACLE-L
Hey Gang;
Anyone here familliar with an "End
Title: RE: VIEWS/ROLES/PRIVS
no she
doesn't. she will be creating the view in her own
schema.
now if
she was to be creating the view in JOE's schema, then she would need create any
view.
Tom Mercadante Oracle Certified Professional
-Original Message-From: Whittle Jerome Cont
Rachel,
>Do please count me in too. I believe Marlene Theriault will be
>there as well, so we might ask if she would be interested.
Can you let Marlene know?
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Kanagaraj
INET: [EMAIL PROTECTED]
Fat City Networ
After I posted what I did, it occurred to me that somebody might think I was
actually trying to give detailed description of how to do it. What I
intended was to present enough of it to make one pause and ask if it is
really, truly necessary and work to prevent it from happening again. If you
ha
"McGill, Wayne L" wrote:
>
> I am part-time DBA for an Oracle system that for reasons
> beyond our control is frozen at 7.3.4, at least for the
> immediate future. I am having some problems and I think
> I know how to correct them but I am asking the old-timers
> to dust off their brains to tell
Title: RE: Dbf Files, Mount Points and Oracle 7
Wayne,
Why in the heck are you worried about tables having multiple extents? The old 'table in one big initial extent' rule died a long time ago. Please read Bhaskar Himatsingka's paper "How to Stop Defragmenting and Start Living: The Definiti
Title: RE: LOCALLY MANAGED TABLESPACE
I think your boss's boss might be relating 'locally' in LMT with standby db location ... who knows ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any o
I live (and work, if I'm lucky) in Denver, but I last visited Minneapolis at
the TCOUG meeting back in mid-July. It was a lot of fun -- a bagpiper
serenaded us at dinner with traditional stuff (i.e. "Campbells are Coming",
"Scotland Forever", and "Amazing Grace", I think) as well as some improv
st
Title: RE: creating a 9.2 database
Did
you run 9.0 or 9.2? The last page for my installer
has
two check boxes
- create template
- create database
Matt Adams - GE Appliances -
[EMAIL PROTECTED]My computer beat me at chess, but I wonwhen it
came to kick boxing.
-Original
Well, heck, count me in. I'll be at OOW too, assuming I can find San
Francisco. Which coast is it on?
--Walt Weaver
Bozeman, Montana
-Original Message-
Sent: Friday, November 01, 2002 12:21 PM
To: Multiple recipients of list ORACLE-L
Do please count me in too. I believe Marlene Theria
I had a similar problem once and it ended up being that a disk was in the
process of starting to fail but hadn't completely failed (and therefore
didn't fail over to the mirror).
This didn't show up in any Solaris logs until *after* the server had been
rebooted, the database had been restarted and
List,
First of all, I want to thank Mladen Gogala and Bing Wong for their
suggestions in helping me resolve my Install problem.
The problem seemed to be not related to Oracle or HPUX, It seemed to be
caused by CA's Unicenter TNG Workload Agent. I shutdown all of the
Unicenter components and t
What's that about the French have a great love for the
health of their liver ???
--- "Sherman, Paul R." <[EMAIL PROTECTED]> a écrit :
> Tom,
>
> Much better to say Fmlp - (F)iche-(m)oi (l)e (p)aye!
> Or better yet say that
> someone's liver is going bad (the French have a
> great love for the he
Wayne,
I don't know about Otacle 10,11 etc.
The direction you are going in in the questions are correct.
1> NO. If you spread the I/O aceoss differnet disks it would eliminate
disk contention
2>YES . See question 1.
3>None that I can see if you need a large table for TEMP. Doing a lot
of sorts???
I have my tables, indexes, system, etc. on different mount
points. That was suggested by several of the gurus when I was getting
ready to move to new servers.
Ruth
- Original Message -
From:
Kevin Lange
To: Multiple recipients of list ORACLE-L
Sent: Friday, Novem
Count me in.
Mike Bates
At 11/1/2002 11:11 AM, you wrote:
Well, heck, count me in. I'll be at
OOW too, assuming I can find San
Francisco. Which coast is it on?
--Walt Weaver
Bozeman, Montana
-Original Message-
Sent: Friday, November 01, 2002 12:21 PM
To: Multiple recipients of list ORAC
Jay,
Is your tablespace type "TEMPORARY" or "PERMANENT". I tried to create
a LMT for type temporary and it is not allowed. Oracle 8.1.7 . The
Oracle 8i DBA Handbook also says that Temporary can not be LMT. It may
allow the creation of an LMT for a permanent tablespace that contains
temporary obje
Jay,
I've been going through this for the first time as well. In 8.1.7 you can a
LMT as a user's temporary tablespace, but as soon as the process try to
create a temp segment, you'll get the ORA- error. So, if you want LMT and
temporary segments you'll need the Temporary tablespace / tempfiles.
Wayne,
First off welcome into the late 20th century. When did NAVAIR move off of
Oracle 5??
Second, the problem your seeing is that there is not one contiguous chunk of
space in the tablespace that will hold the table with the new storage. But as
another list member noted you don't need
Hey Walt,
You should be able to hop onto your sailplane and glide from the Montana
mountain tops towards the West coast. Dick Goulet (exUSAF Radar) should be
able to provide you a glide-path :)
Now this is getting OT and I need to watch my mouth (oops I meant my
fingers!)
John
>-Original M
Not sure about 8.1.7, but in 9.2 "TEMPORARY" could be LMT.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, November 01, 2002 3:21 PM
Jay,
Is your tablespace type "TEMPORARY" or "PERMANENT". I tri
Paula,
Even if I'm not on that list of names make sure you find me at IOUG
to say hi :)
Rachel
--- [EMAIL PROTECTED] wrote:
> If it is a get together for dinner after IOUG live in April in
> Orlando I
> would even pick up the bill for a couple of names on this list. (I
> get to
> choose the
1 - 100 of 117 matches
Mail list logo
