where table is stored in oracle

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • hiral amit patel
    New Member
    • Jul 2009
    • 5

    where table is stored in oracle

    we are using create table command for creating a table
    my question is what is the default path of that table.
    can i save that table in my own path.
    if so then what is the syntax
    what is the extension of of that table
  • amitpatel66
    Recognized Expert Top Contributor
    • Mar 2007
    • 2358

    #2
    You can specify the tablespace where you want to store your table. I hope you understand the logical structure of the database like Data blocks, extent,segment and tablespace. If you are not aware of the same then please go through the theoritical concepts from some good oracle book.

    Comment

    • debasisdas
      Recognized Expert Expert
      • Dec 2006
      • 8119

      #3
      What do you mean by your own path ? A table in oracle is not a file that you will store in a particular location in hard drive.

      You need to understand what is a data file , what is a table space and need to go through the complete syntax of create table (with table space clause)

      Comment

      Working...