Re: How a row is physical stored in Oracle

"Najm Hashmi" <najmhashmi_at_videotron.ca> wrote in news:8ERwk.7$TJ.1032_at_weber.videotron.net:

> Hi All,
> I was just curious to know rows are physically stored for a table in
> Oracle database. Are they stored by Primary Key? If I don't want to
> store them by primary key but some other column, how will I be able to
> do it.
>
> I would appreciate if someone can point me to some documentation and
> few good reference books.
>
> My background is in SQL Server and I am pretty much aware of its
> internals. I would like to do the same with Oracle. I would appreciate
> your help on the books and links.
>
> Best regards,
> Najm
>
>
>

> Are they stored by Primary Key?

HUH?
> If I don't want to store them by primary key but some other column, how
will I be able to do it.

I have no idea what you mean by this.

Rows/columns do not need to be indexed.

http://tahiti.oracle.com
& read the Concepts Manual. Received on Sun Sep 07 2008 - 10:00:18 CDT