JDBC Driver, catalogs and tablspaces.. I'm confused

[KrisSimonis]

Ok, Oracle has tablespaces to put tables in, is there any way I can ask a connection to an Oracle database for any information on them? Like which tablespaces exist for instance, through metadata?
Kris Simonis
Topdesk Information Systems,
Application Server Development

"You haven't seen the last of Meeaaaarrrrghh!!!"
- Several bad guys in several bad movies

 

[stefanhei]

Hi.
With a privileged user you can issue:
select tablespace_name from dba_tablespaces
or
select * from v$tablespaces

Stefan

 

[KrisSimonis]

Is there any way I can retrieve this information from the connection meta data object?
Kris Simonis
Topdesk Information Systems,
Application Server Development

"You haven't seen the last of Meeaaaarrrrghh!!!"
- Several bad guys in several bad movies