-
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][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
Hudson
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|