names [message #501] |
Sat, 16 February 2002 02:52 |
Richard
Messages: 44 Registered: May 2000
|
Member |
|
|
I'm very new to Oracle/SQL.
How can I write a single script that shows a table_name, tablespace_name and data file name for the table.
|
|
|
Re: names [message #502 is a reply to message #501] |
Sat, 16 February 2002 16:51 |
Suresh Vemulapalli
Messages: 624 Registered: August 2000
|
Senior Member |
|
|
select a.table_name,a.tablespace_name,b.file_name
from dba_tables a,dba_data_files b
where owner=user
and a.tablespace_name=b.tablespace_name
|
|
|