No you don't.
As long as the OS can handle it, you just resize the datafile.
I've got single datafiles of 50gb+
Michael Peel
-----Original Message-----
From: Schwalm Bruce
[mailto:oracledba-ezmlmshield-x8270632.[Email address protected]
Sent: 30 April 2008 14:03
To: LazyDBA Discussion
Subject: RE: How to increase or resize the data file
Has the TABLESPACE reached it's maximum, or has the FILE reached it's
maximum?
If it's the FILE, you will have to add another datafile.
Bruce Schwalm
-----Original Message-----
From: Michael Peel
[mailto:oracledba-ezmlmshield-x79629531.[Email address protected]
Sent: Wednesday, April 30, 2008 5:17 AM
To: LazyDBA Discussion
Subject: RE: How to increase or resize the data file
Alter database datafile '<full_path_of_datafile> resize <newsize>;
Michael Peel
-----Original Message-----
From: eic [mailto:oracledba-ezmlmshield-x31078155.[Email address
protected]
Sent: 30 April 2008 08:02
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
**********************************************************************
This e-mail is confidential and may be privileged.
It may only be read, copied and used by the intended recipient.
If you have received it in error please contact the sender immediately
by return e-mail. Please then delete the e-mail and any copies of it and
do not use or disclose its contents to any person.
**********************************************************************
Registered Office: Farncombe House, Broadway, Worcestershire, WR12 7LJ
AccuRead Limited Registered Number: 3076187 England GSL UK Limited
Registered Number: 3333860 England Global Solutions Limited Registered
Number: 3189802 England
**********************************************************************
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
**********************************************************************
This e-mail is confidential and may be privileged.
It may only be read, copied and used by the intended recipient.
If you have received it in error please contact the sender immediately
by return e-mail. Please then delete the e-mail and any copies of it
and do not use or disclose its contents to any person.
**********************************************************************
Registered Office: Farncombe House, Broadway, Worcestershire, WR12 7LJ
AccuRead Limited Registered Number: 3076187 England
GSL UK Limited Registered Number: 3333860 England
Global Solutions Limited Registered Number: 3189802 England
**********************************************************************
Oracle LazyDBA home page