Re: Database migration question.

From: John Campbell <john.campbell7_at_virgin.net>
Date: Fri, 27 Sep 2002 17:39:09 +0100
Message-ID: <mP%k9.1538$XC6.45981@newsfep1-win.server.ntli.net>

There are a number of data dictionary views you can query to get the information you require.
Tablespace info can be found in:
DBA_TABLEPSACES
V$TABLESPACE
USER_TABLEPSACES The datafile, tables etc have similar views to query. The DICTIONARY table contains a list of all these views and can be queried to find the info you require. e.g.

select * from dict where table_name like '%TABLESPACE%';

will give you a list of views with the word "TABLESPACE" in them. So for datafiles substitute the word "TABLESPACE" for "DATAFILE"

Hope this helps

John

"Praveen" <pmohanan_at_netscape.net> wrote in message news:3D94735F.6020103_at_netscape.net...
> 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/
>
Received on Fri Sep 27 2002 - 11:39:09 CDT