Re: How to find next extent size for all tables in database
Date: Wed, 1 Jul 2009 09:40:28 -0400
select owner, table_name, next_extent from dba_tables;
But do you even care about that anymore, if you're using locally managed tablespaces, since most of them will be null in a LMT, right?
This is just off the top of my head, i'm sure if i'm in left field, someone will correct me :)
Joe Testa, Oracle Certified Professional
Interested in helping out your marriage?
Ask me about "Weekend to Remember"
Dec 11-13, 2009 here in Columbus.
nilesh kumar <nileshkum_at_gmail.com>
07/01/2009 09:36 AM
How to find next extent size for all tables in database Sent by:
Hope Everyone is doing good!!
I have a question and requirement regarding finding the next extent size of all the tables residing in all the tablespaces in a database. Have any one does this type of stuff. Please advise.