How do I know what my tablespace is named?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: How do I know what my tablespace is named?

  1. #1
    Join Date
    Feb 2001
    Posts
    5

    Talking

    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!

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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

  3. #3
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356

    Thumbs up

    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]

  4. #4
    Join Date
    Feb 2001
    Location
    Montreal
    Posts
    29

    Talking

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


Click Here to Expand Forum to Full Width