| Datafile size [message #331848] |
Sun, 06 July 2008 00:55  |
balaji1482
Messages: 312
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 #331900 is a reply to message #331848] |
Sun, 06 July 2008 09:18  |
pablolee
Messages: 2882
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 #331994 is a reply to message #331911] |
Mon, 07 July 2008 03:27 |
balaji1482
Messages: 312
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] Report message to a moderator |
|
|
|
| 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 Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
