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!
Printable View
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]
Connect like system , sys or internal on SqlplusQuote:
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!
-- 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