Re: storage clause help!!!!!
From: wozi <wozi_at_dhc.net>
Date: Sat, 1 Jan 2000 15:40:37 -0800
Message-ID: <45AA7B4ED5E306FE.68E937A32BA4FBE6.824B9DD68E3AD76F_at_lp.airnews.net>
Date: Sat, 1 Jan 2000 15:40:37 -0800
Message-ID: <45AA7B4ED5E306FE.68E937A32BA4FBE6.824B9DD68E3AD76F_at_lp.airnews.net>
Serge Nantel wrote in message <386BA614.217F175F_at_sympatico.ca>...
>Help I need a script to retrieve all the storage clause from a Oracle
>database 7.3.x can some one help me with this!
>
>Thank you kindly
>snantel_at_sympatico.ca
>
Storage clause can be set for tablespaces as well as for each tables and
indexes.
You can query dba_tablespace, all_tables, all_indexes etc for storage clause
option.
If you have Oracle Enterprise Manager, you can use the Storage Manager utility as well.
good luck Received on Sun Jan 02 2000 - 00:40:37 CET