Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    67

    Unanswered: Primary Storage Location

    How to find the Primary storage location on a Oracle Database for different oracle instances.

    Also how to find the primary storage type.

    any help on this would be higly appreciated

    thanks
    Shankar

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    sql> select file_name from dba_data_files;

    will give you the list of data files making up the database. Not sure what you are looking for in type... dba_tablespaces may give you some of the information you are looking for.

    HTH
    Gregg

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •