Home » SQL & PL/SQL » SQL & PL/SQL » Display information of a table
Display information of a table [message #20026] Thu, 25 April 2002 07:15 Go to next message
Lissa Wong
Messages: 4
Registered: March 2002
Junior Member
How do I display segment name, extent ID, Block ID, number of Blocks of a particular table?

Report message to a moderator

Re: Display information of a table [message #20027 is a reply to message #20026] Thu, 25 April 2002 08:11 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
select extent_id,block_id,blocks from dba_extents where segment_name='TABLENAME' and owner='OWNER'

Report message to a moderator

Previous Topic: Calling Procedure in another schema
Next Topic: Count of updated rows...
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 05:50:22 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.