Behave children. ;)
No, I wasn't reading the list. Another story...
Jared
On Tuesday 10 December 2002 10:20, Rachel Carmichael wrote:
1) he's reading the list while traveling
2) I'm having dinner with him tonight I'll tell him
:)
--- Ruth Gramolini [EMAIL PROTECTED] wrote:
Stop
From bitter experience:
Do not allow your datafile to autoextend across 4GB boundary.
There is a bug that cause this datafile to be unusable.
We had an all night session after this bug hit us.
We had to call Oracle to come with the DUL utility to
recover the data.
Now we define our datafiles to
On Wed, 11 Dec 2002, Yechiel Adar wrote:
Do not allow your datafile to autoextend across 4GB boundary.
There is a bug that cause this datafile to be unusable.
I think the 4Gb limit is confined to a handfull of older operating
system versions or older Oracle versions. For about the last five
Hello Jeremiah
I did some research on metalink and it says:
1) Do not use datafiles more then 4GB on NT systems.
2) There is a bug on NT, W2K that if you resize datafile (direct command or
autoextend) to 4GB boundary, i.e 4,8,12, then there are two conditions:
2.1) No archive log - database
Yechiel,
Thanks for pointing out the potential issues with autoextending onto an exact 4 Gb
boundary (as I forgot to include them).
Reading the bug you referenced (at
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=BUGp_id=1668488)
it says:
...
Does not
Jeremiah,
I am seeking for help. If you are not willing to help then just SHUT your
mouth. I don't think we welcome such people like you here.
David
-Original Message-
Sent: Monday, December 09, 2002 5:39 AM
To: Multiple recipients of list ORACLE-L
On Mon, 9 Dec 2002, Nguyen,
David,
If my three year old said that, he'd be on the step immediately. Jeremiah
has helped a lot of people on this list. The point is that you need to take
a certain amount of responsibility to do some research before posting a
question (i.e. metalink, tahiti.com, ...). Also, all answers should
Title: RE: Increase size of data files and rollback segments
I disagree! I do welcome Jeremiah's input on this list. David, I think you missed the smiley attached to his message.
-Original Message-
From: Nguyen, David M [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 10
Stop fighting children, or I will have to tell Daddy Jared when he gets
back. Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 10, 2002 12:15 PM
I disagree! I do welcome Jeremiah's input on this list. David, I think
you
Title: RE: Increase size of data files and rollback segments
What bothers me is why can't you use sqlplus? Why do you need GUI tool?
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed
Speak for yourself, man. I think the type of people we don't welcome
here is those who don't bother to read a doc on something as trivial as
how to increase the size of datafile and can't take a joke.
Richard
-Original Message-
Sent: Tuesday, December 10, 2002 10:50 AM
To: Multiple
Title: RE: Increase size of data files and rollback segments
Au
contraire, I welcome Jeremiah just about anywhere, as long as he doesn't drink
too much of my beer.
Read
between the lines, David.There's a message there.
:)
--Walt
Weaver
Bozeman, Montana
-Original Message
David,
Wrong. we very much welcome Jeremiah here. He has helped countless
people on this list, and if he on occasion chooses to make a joke (as
do we all), then so be it.
He was a good deal gentler and nicer than my first thought, which was
to tell you to read the fine manual before asking basic
1) he's reading the list while traveling
2) I'm having dinner with him tonight I'll tell him
:)
--- Ruth Gramolini [EMAIL PROTECTED] wrote:
Stop fighting children, or I will have to tell Daddy Jared when he
gets
back. Ruth
- Original Message -
To: Multiple recipients of list
I welcome David input always, especially when he is yanking the leg of
someone who did not troubled himself to open the SQL manual and look at
obvious commands like alter rollback segment and alter tablespace.
I liked his answer.
BTW, Please do not tell ANYONE on this list to shut up.
It is bad
Title: RE: Increase size of data files and rollback segments
ORACLE ORACLE ORACLE ORACLE SQL*NET
Just bringing it back on topic :)
Nick
-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 10:21 AM
To: Multiple recipients
Walt,
Your french is pretty good !
--- Weaver, Walt [EMAIL PROTECTED] a écrit :
Au contraire, I welcome Jeremiah just about
anywhere, as long as he doesn't
drink too much of my beer.
Read between the lines, David. There's a message
there. :)
--Walt Weaver
Bozeman, Montana
Thanks, I had to drop off the Lazy DBA list because of all the sniping. I
would hate to have to drop off Jared's list too.
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 10, 2002 1:20 PM
1) he's reading the list while
Alright guys, just because you know Jeremiah better than me so you can take
his joke. My apology to him as I did not recognize it was a joke, however
when I am asking for help from the group, I am in a situation to resolve
problem ASAP and hope to find a answer not a joke.
If you were in my
Title: RE: Increase size of data files and rollback segments
From: Nguyen, David M [mailto:[EMAIL PROTECTED]]
Alright guys, just because you know Jeremiah better than me
so you can take
his joke.
I have no idea who Jeremiah is from Adam, and I got the joke. Hell, I nearly flamed you
David,
As a start, look up the following commands in the SQL Reference guide:
alter database datafile 'C:\ORADATA\fred\DAT_LARGE_01.dbf' autoextend on maxsize
20480M;
Read up on the implications of autoextend and whether you want it
alter database datafile
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76956/dfiles.htm
-Original Message-From: Nguyen, David M
[mailto:[EMAIL PROTECTED]]Sent: Monday, December 09, 2002 5:24
AMTo: Multiple recipients of list ORACLE-LSubject:
Increase size of data files and
On Mon, 9 Dec 2002, Nguyen, David M wrote:
How do I increase size of oracle data files and rollback segments and Can I
do it when database is online?
Unfortunately these sizes are fixed, and based on your level of
license with Oracle Corp. If you need to increase the size of your
datafiles or
A cruel joke Jeremy!
BTW may be you can help me out here. I am not receiving back any of the
messages I send to the the list and I do not know if list is receiving my
messages either.
Do you know how to solve this problem?
Thanks in advance
Shaleen Garg
- Original Message -
To: Multiple
24 matches
Mail list logo