楗洅鍗氬

绀轰緥锛�

SELECT table_name,tablespace_name,TEMPORARY

FROM user_tables

WHERE table_name LIKE '%PROV%'

鍒嗘瀽锛�
銆�銆�table_name:琛ㄥ悕锛坴archar2(30)锛�;
銆�銆�tablespace_name:瀛樺偍琛ㄥ悕鐨勮〃绌洪棿锛坴archar2锛�30锛夛級锛�