Re: Database migration question.

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Fri, 27 Sep 2002 16:56:23 GMT
Message-ID: <3D948DA7.35787304@exesolutions.com>

Praveen wrote:

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

If you are looking at what I think you are looking at SQL is irrelevant. Go to the operating system and add up the log files, control files, and data files. The size of what is inside them is irrelevant.

Daniel Morgan Received on Fri Sep 27 2002 - 11:56:23 CDT