Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Changing autoextend options of a datafile

Changing autoextend options of a datafile

From: Steven Monaghan <MonaghaS_at_mscdirect.com>
Date: Fri, 15 Sep 2000 16:57:38 -0400
Message-Id: <10620.117177@fatcity.com>


I have a datafile for rollback segments that has NEXT=8Kb, MAXSIZE=33Gb.

How do I change these settings? I am looking through the oracle docs and can only find a description of these parameters when adding a data file. Am I stuck dropping and re-creating the data file / tablespace, or is it just a Friday afternoon thing that is really simple that I can't figure out?

Steve



Steven Monaghan
Oracle DBA
MSC Industrial Direct Co., Inc.
Melville, NY
MonaghaS_at_mscdirect.com
Received on Fri Sep 15 2000 - 15:57:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US