OraFAQ Forum: SQL & PL/SQL

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.

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

Previous Topic:	Pass parameter list to IN clause of cursor
Next Topic:	Column names function

Goto Forum:

]

Current Time: Tue Apr 23 10:36:43 CDT 2024