| Datafile size [message #331848] |
Sun, 06 July 2008 00:55  |
balaji1482
Messages: 166
Registered: July 2007
Location: INDIA |
Senior Member |
|
|
hi all,
if tablespace becomes full in space ,should we resize a datafile or add datafile??
Please suggest me.
|
|
|
| Re: Datafile size [message #331862 is a reply to message #331848 ] |
Sun, 06 July 2008 02:13  |
Michel Cadot
Messages: 18894
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
As you want.
Regards
Michel
|
|
|
| Re: Datafile size [message #331900 is a reply to message #331848 ] |
Sun, 06 July 2008 09:18 |
pablolee
Messages: 1092
Registered: May 2007
Location: Scotland |
Senior Member |
|
|
| balaji1482 wrote on Sun, 06 July 2008 06:55 | hi all,
if tablespace becomes full in space ,should we resize a datafile or add datafile??
Please suggest me.
|
Yes
|
|
|
| Re: Datafile size [message #331911 is a reply to message #331848 ] |
Sun, 06 July 2008 09:52 |
Littlefoot
Messages: 6444
Registered: June 2005
Location: Croatia, Europe |
Senior Member |
|
|
|
I'm not saying that this is the best way to do that, but here's what we used to do: we added a new data file (let's assume that the first one was 4 GB and another, newly created one 2 GB). Then, when we recreated the database, we have created a single datafile having size of 6 GB. So, perhaps you could consider such an option as well.
|
|
|
| Re: Datafile size [message #331994 is a reply to message #331911 ] |
Mon, 07 July 2008 03:27 |
balaji1482
Messages: 166
Registered: July 2007
Location: INDIA |
Senior Member |
|
|
hi Littlefoot,
Instead of recreating a new database and creating a datafile with a size of 6GB, i would suggest you to resize the old datafile with a size from 4 GB to 6GB.
hope it is clear.
Regards,
Balaji
[Updated on: Mon, 07 July 2008 03:28]
|
|
|
| Re: Datafile size [message #332794 is a reply to message #331848 ] |
Wed, 09 July 2008 14:02 |
grumpydba
Messages: 5
Registered: July 2008
Location: Denver, Colorado |
Junior Member |
|
|
That is another "it depends" kind of question. You can increase the file size, but it is limited by your block size, 4k-16G 8k-32G, 16k-64G, etc. So if you have a large datafile your only option is to add another datafile. If you have the space, you can create (10g and higher) a big-file tablespace (BFT) which can be up to 2^32 * blocksize or 32T for 8k. BFT's can have only 1 datafile.
Cheers,
Jay Caviness
[Updated on: Wed, 09 July 2008 14:06] by Moderator
|
|
|
|
]
Members
Search
Help
Register
Login
Home
