How do I know what my tablespace is named?

[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!

[pando]

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

[sudip]

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]

[hudson]

[QUOTE][i]Originally posted by heather [/i]
[B]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! [/B][/QUOTE]
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