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