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

This article mainly explains "Oracle how to look up the table space and the address of the data file according to the table name", interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn how Oracle looks up the address of tablespaces and data files according to table names.

Select t1.name, t2.name from v$tablespace T1, v$datafile T2 where t1.ts# = t2.ts#

SELECT * FROM v$tablespace

SELECT * FROM v$datafile

At this point, I believe you have a deeper understanding of "Oracle how to look up tablespaces and data file addresses according to table names". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.