Hello Everyone
I wanted to make sure that my understandings is correct in related to DATA FILE. Below is what i have understood. Please advise if my understanding is wrong. So, When we create a table, oracle is going to create special storage unit and that storage unit is called SEGMENT.
Question : How do i define segment size at the time of create statement ? Lets assume like this is the table i want to create -----> create table tt(sal varchar2(20)); but i wanted to define segment size as well while creating table tt ? So my question here is what is the query to define segment size at the time of creating table tt ? Will appreciate if you could guide me with query example.
Answer :