Home » RDBMS Server » Server Administration » can segment extend if file is autoextend off
can segment extend if file is autoextend off [message #182949] Tue, 18 July 2006 22:37 Go to next message
abs_amit
Messages: 59
Registered: January 2006
Location: delhi
Member
Hi all,

I have two datafiles in a tablespace both are autoextend off what will happen if one datafile is 100% full but second datafile is 10% full. what about segments in first datafile ..can they extend automatically in second datafile?????????

Report message to a moderator

Re: can segment extend if file is autoextend off [message #182980 is a reply to message #182949] Wed, 19 July 2006 01:23 Go to previous message
aciolac
Messages: 242
Registered: February 2006
Senior Member
Yes. Segments can extend to any datafile of tablespace, where they are situated.

Report message to a moderator

Previous Topic: How to replace the damaged table by backup table
Next Topic: How can I find session which had started(submited) job ?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 09:32:19 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.