OraFAQ Forum: SQL & PL/SQL » Current table extent

Home » SQL & PL/SQL » SQL & PL/SQL » Current table extent

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Current table extent [message #7000]

Wed, 14 May 2003 22:04

Wanchun
Messages: 4
Registered: May 2003

Junior Member

Please help.
I just can find the max_extents from the user_tables. However, how can i know the current extent of the table. Because, I need to know the table will be reached the max_extents or not, thanks.
Urgent!!!!

Report message to a moderator

Re: Current table extent [message #7002 is a reply to message #7000]

Wed, 14 May 2003 23:55

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

select count(*)
  from user_extents
 where segment_name = :table_name;

Report message to a moderator

Re: Current table extent [message #7004 is a reply to message #7002]

Thu, 15 May 2003 00:09

Wanchun
Messages: 4
Registered: May 2003

Junior Member

Thanks Thanks
May I have your email address and ask you question later???
Thanks

Report message to a moderator

Re: Current table extent [message #7019 is a reply to message #7004]

Thu, 15 May 2003 12:07

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

Feel free to post any questions you have here. There are many capable people monitoring the questions.

Report message to a moderator

Previous Topic:	trigger in update or delete on 100+ tables w/ different owners.
Next Topic:	Want to check and see if a datafield in one table EXISTS in the other table or not..

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 23:59:29 CDT 2024