Re: How a row is physical stored in Oracle

Najm Hashmi wrote,on my timestamp of 8/09/2008 12:33 AM:

> 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.

Start here:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/toc.htm then follow up as needed from here:
http://www.oracle.com/pls/db102/portal.portal_db?selected=3 If it asks you to register at any stage, do: it's free, no spam. Received on Sun Sep 07 2008 - 09:50:50 CDT