How do I know what my tablespace is named?

I had oracle installer create a database for me. How do I know what the name of the tablespace that it created is? Thanks for any help you can give me!

there are system tables (data dictionary) that give you the information about virtualluy anything in the database such as tablespace name, run sqlplus as system and query dba_tablespaces

Hi!
Login as System and query dba_tablespaces to query about the tablespaces in the database. for quering about the associated datafiles fire the following query
SELECT A.name Tablespace, b.name Datafilename
from v$tablespace a , v$datafile b
where a.ts# = b.TS#

Sudip

[Edited by sudip on 02-19-2001 at 12:10 AM]

Quote:

---

Originally posted by heather
I had oracle installer create a database for me. How do I know what the name of the tablespace that it created is? Thanks for any help you can give me!

---

Connect like system , sys or internal on Sqlplus

-- Tablepace name only
select tablespace_name from dba_tablespaces;
or
-- Tablepace name and the file name
select tablespace_name , file_name from dba_data_files;

H