where table is stored in oracle

hiral amit patel

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

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.

debasisdas

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)

where table is stored in oracle

re: where table is stored in oracle

re: where table is stored in oracle

Similar Oracle Database bytes

/bytes/development

/bytes/it

/bytes/about