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
Re: Extent Allocation [message #284794 is a reply to message #284780] Sat, 01 December 2007 03:19 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
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:
  


Current Time: Sat Dec 10 20:19:21 CST 2016

Total time taken to generate the page: 0.04993 seconds