RE: Increase size of data files and rollback segments

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:david.m.nguyen_at_xo.com]
>
> 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: Bruce.Reardon_at_comalco.riotinto.com.au

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: ListGuru_at_fatcity.com (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).