How to retrieve default/current datafile name and tablespace name through SQL query?

Vote count:

0

If i have just a oracle schema name then how can i retrieve all the properties/attributes of that schema in respect to the DB name, Datafile name and tablespace name. Along with the space allocated to them.

asked 49 secs ago

Prashant

77

How to retrieve default/current datafile name and tablespace name through SQL query?