Home » Other » General » Datafile size (solaris)
Datafile size [message #331848] Sun, 06 July 2008 00:55 Go to next message
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 #331862 is a reply to message #331848] Sun, 06 July 2008 02:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As you want.

Regards
Michel
Re: Datafile size [message #331900 is a reply to message #331848] Sun, 06 July 2008 09:18 Go to previous messageGo to next message
pablolee
Messages: 2834
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 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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

Re: Datafile size [message #333246 is a reply to message #332794] Fri, 11 July 2008 00:28 Go to previous message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

thanks for your information
Previous Topic: Status of Standby database
Next Topic: Differences
Goto Forum:
  


Current Time: Sat Dec 03 12:02:32 CST 2016

Total time taken to generate the page: 0.04456 seconds