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 'C:\ORADATA\fred\DAT_LARGE_01.dbf' resize 10240M;
For rollback datafile - same as any other datafile, eg:
alter database datafile 'C:\ORADATA\fred\ROLLBACK1.DBF' autoextend on maxsize 10240M;
You may then need to add another rollback segment or increase the max extents of an
existing one. eg to add another rollback segment:
CREATE PUBLIC ROLLBACK SEGMENT r09_big
TABLESPACE rollback
STORAGE
( minextents 20
INITIAL 10M
NEXT 10M
MAXEXTENTS UNLIMITED)
(you would then need to bring this online - eg "alter rollback segment r09_big
online;")
For tempfile (ie LMT temporary tablespaces):
alter database tempfile 'C:\ORADATA\fred\TEMP1.dbf' autoextend on maxsize 10240M;
Remember - don't use the exact sizes I've shown - alter to suit your case (these were
part of a huge load into a new test system)
Hope this helps (and willing to learn if some of the above could be improved).
Regards,
Bruce
-----Original Message-----
Sent: Wednesday, 11 December 2002 8:15 AM
> 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 myself, and I'm just a lowly developer.
> 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.
The problem is that if enough people like you refuse to RTFM, then no one will want to
answer questions because it'll be duller'n your resume.
> If you were in my situation, you would understand.
I've been in your situation, and been damned ashamed of myself for not having
researched the question first. It ain't all that hard...
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reardon, Bruce (CALBBAY)
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
