Home » RDBMS Server » Server Administration » extending tablespace or creating new datafile
extending tablespace or creating new datafile [message #53349] Sat, 14 September 2002 05:52 Go to next message
artan
Messages: 2
Registered: September 2002
Junior Member
Hello dear Oracle Forum,

I would like to know if it is better to extend the existing tablespace when it is getting full or to create a new datafile within that tablespace???

Thank u

Report message to a moderator

Re: extending tablespace or creating new datafile [message #53375 is a reply to message #53349] Mon, 16 September 2002 19:42 Go to previous message
Phil
Messages: 32
Registered: March 2001
Member
Makes no real difference. Depending on the OS, there is a filesize limitation. You also stand a better chance of Oracle finding a larger extent with a larger filesize, but that's about it.

Report message to a moderator

Previous Topic: Re: Trying To identify the table that gives ORA-01631 error
Next Topic: Re: ORACLE 8 & 8i Paper Available :)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Feb 19 05:00:42 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.