Table - Logical structure

[nkumarin001]

Hi,

a) What is the use of create table as it is logical structure and will not consume any space so why do we need it?
b) What happens when we give create table command?

Regards,
Naveen

[debasisdas]

Hi
Naveen

Please do not post duplicate threads in the forum.

[r035198x]

Hi,

a) What is the use of create table as it is logical structure and will not consume any space so why do we need it?
b) What happens when we give create table command?

Regards,
Naveen

For theoretical type questions, it is best to consult a text.

[sanora600]

For theoretical type questions, it is best to consult a text.

Gud question...........

I must tell you that it is not only table, tablespace,extent and the database itself is a logical structure.

Now coming to your question........... Why you need table?
consider this senario:

See, if I tell you to find a book in a library which have some lahks of Unique books. then how much time you will take to find that book?

lots of time because you have to check all the books till you find required book. In worst case you will find that books in the end of your search.

But suppose I divide all the books in library on some means example depending on their content like oracle , java, HTML and so on..... Then you will search the category first and then in that category you will find your book.
It will dramatically decrease the search time.


Oracle is no different then this library. data is no different than your book and logical structure is like a mean to divide that book. this is the reason oracle has introduce the concept of logical space management. Please let me know if I am not clear. I will try to help you. my id is <Removed>

[nkumarin001]

Gud question...........

I must tell you that it is not only table, tablespace,extent and the database itself is a logical structure.

Now coming to your question........... Why you need table?
consider this senario:

See, if I tell you to find a book in a library which have some lahks of Unique books. then how much time you will take to find that book?

lots of time because you have to check all the books till you find required book. In worst case you will find that books in the end of your search.

But suppose I divide all the books in library on some means example depending on their content like oracle , java, HTML and so on..... Then you will search the category first and then in that category you will find your book.
It will dramatically decrease the search time.


Oracle is no different then this library. data is no different than your book and logical structure is like a mean to divide that book. this is the reason oracle has introduce the concept of logical space management. Please let me know if I am not clear. I will try to help you. my id is <Removed>

Hi sanora600,

Thanks for u r valuable answer it helped me a lot.

Regards,
Naveen

[prakash331]

Hi sanora600,

Thanks for u r valuable answer it helped me a lot.

Regards,
Naveen

That i s really nice example.
Thank u sanora600.........