Home » RDBMS Server » Server Administration » Extent Allocation
Extent Allocation [message #284780] Sat, 01 December 2007 01:21 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
Dear All,

will it be possible to know when the last extent was allocated to a segment (EMP)?
for example we a table segment EMP
I want to know latest extent allocated to the table segment EMP with time/date of allocation.

Regards,
M.Shakeel Azeem

Report message to a moderator

Re: Extent Allocation [message #284794 is a reply to message #284780] Sat, 01 December 2007 03:19 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No it is not possible unless you mine your (archived) logs and are an expert in reading sys table updates.

Regards
Michel

[Updated on: Sat, 01 December 2007 03:19]

Report message to a moderator

Previous Topic: Java Exceptions while installing Oracle
Next Topic: Altering a Table Partition
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 30 01:40:55 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.