select table_name,tablespace_name,temporary from user_tables [where table_name=表名] 

select column_name,data_type ,data_length,data_precision,data_scale from user_tab_columns [where table_name=表名]; 
注：表名变量值必须大写。 
或
select * from all_tab_columns where table_name='TEST_TEMP';