Search
  • Arun Kumar
    • 1 min read

Find Datafiles Associated with Tablespace

FIND TABLESPACES IN DATABASE


select name from v$tablespace;

OR

select tablespace_name from dba_tablespaces;

QUERY TO FIND DATAFILES ASSOCIATED WITH A TABLESPACE


SQL> select tablespace_name, file_name, bytes/1024/1024 from dba_data_files where tablespace_name='&tablespace_name';



SQL> select file_name, bytes/1024/1024 from dba_temp_files;

138 views

Recent Posts

See All

Oracle 12c to 19c Database Upgrade

In this article we will be looking at two most commonly used methods of upgrading Oracle database from 12c to 19c Pre-upgrade tasks Upgrade using DBUA Upgrade using Manual Method You can perform a dir