1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Tables Storage Path

Discussion in 'General' started by robin, Feb 10, 2011.

  1. robin

    robin Forum Advisor

    Messages:
    55
    Likes Received:
    7
    Trophy Points:
    160
    Location:
    Hyderabad
    Hi,

    I have installed Oracle 10g in my computer.Could anyone plz give the path where the sql tables(the queries,the tables ,procedures everything we create) are stored ?

    Thanks in Advance
     
  2. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    Database Files.

    You are referring to Datafiles.

    Pleas refer dba_data_files.
     
  3. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,351
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Where objects are stored depends upon what the object types are; user-created tables/indexes are stored in files associated with regular tablespaces (such as those named USERS, APP_DATA, etc.); stored procedures, functions, packages, triggers and other source objects are stored in the SYSTEM tablespace; operational tables (those Oracle needs to actually run) are stored in the SYSTEM and SYSAUX tablespaces. Some object types have specialized tablespaces solely for their use, such as UNDO segments (the UNDO tablespace) and sort and hash segments (the temporary tablespace). All of this is covered in the Concepts Guide, located here:

    http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/toc.htm

    It would be a very good idea to start reading it to understand Oracle.
     
  4. robin

    robin Forum Advisor

    Messages:
    55
    Likes Received:
    7
    Trophy Points:
    160
    Location:
    Hyderabad
    @raj and Zargon

    Thanks for the reply guys.I found your material very helpful..