Shulou(Shulou.com)06/01 Report--

View tablespace, tablespace file path

-- View tablespace

Select * from dba_tablespaces

-- View tablespace file path

Select tablespace_name,file_id,bytes/1024/1024 byte size MB,file_name from dba_data_files order by file_id

-- View the relationship between the user and the default tablespace

Select username,default_tablespace from dba_users

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.