Which size limit did you reach? Is this inside of Oracle, that is: has
all of the freespace been used in one or more tablespaces, and the
datafiles are not set to auto-extend?

Or, is this an O/S or storage system limit that you have reached because
auto-extend is turned on?


-----Original Message-----
From: eic
[mailto:oracledba-ezmlmshield-x31078155.[Email address protected]
Sent: Wednesday, April 30, 2008 3:02 AM
To: LazyDBA Discussion
Subject: How to increase or resize the data file

Dear Guys

The file size of some of the data file seems reaches the maximum limit.
I
just want to increase the data file size. Please tell me the steps I
have to
follow to increase the size. Thanks



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




THE INFORMATION CONTAINED IN THIS E-MAIL MESSAGE AND ANY ATTACHMENTS SENT FROM GENTEX CORPORATION IS GENTEX CONFIDENTIAL INFORMATION INTENDED ONLY FOR THE PERSONAL USE OF THE INDIVIDUAL OR ENTITY NAMED ABOVE. If you are not the intended recipient, you are hereby notified that any review, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the sender by return e-mail, and delete this e-mail message and any attachments from your computer. [gntx v.1]

Oracle LazyDBA home page