dbTalk Databases Forums  

show table parameters

comp.database.oracle comp.database.oracle


Discuss show table parameters in the comp.database.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
vertigo
 
Posts: n/a

Default show table parameters - 11-21-2004 , 04:25 AM






Hello
How can i check table parameters (it's actual size, and storage
parameters such as PCTINCREASE ...) ?

I tried to find my table:
select * from dba_tables where table_name='test' but did not find, why ?

Thanx
Michal


Reply With Quote
  #2  
Old   
Daro
 
Posts: n/a

Default Re: show table parameters - 11-28-2004 , 07:17 AM






try:

select * from dba_tables where table_name='TEST' and owner='OWNER'
or (loged in as owner of table TEST)
select * from user_tables where table_name='TEST'

bye

Dnia 11/21/2004 11:25 AM, Użytkownik vertigo napisał:
Quote:
Hello
How can i check table parameters (it's actual size, and storage
parameters such as PCTINCREASE ...) ?

I tried to find my table:
select * from dba_tables where table_name='test' but did not find, why ?

Thanx
Michal


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.