Database migration question.

Hi..All,

     We are migrating on of our Oracle 8i database from one machine to another. So, we are trying to find out, the lay out of the database i.e tablespaces,datafiles,tables associated with particular tablespace, partitioning etc. and ofcourse there sizes.

Are there any SQL's which will help me in doing so.

TIA Praveen

-- 
Your favorite stores, helpful shopping tools and great gift ideas.
Experience the convenience of buying online with Shop_at_Netscape!
http://shopnow.netscape.com/