Re: Commands Used to Create Existing Contraint and Index

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sat, 31 Jul 2004 08:03:49 +0200
Message-ID: <410b35ce$0$29428$626a14ce@news.free.fr>

"Michael" <melliott42_at_yahoo.com> a écrit dans le message de news:91721cf.0407301542.5db44354_at_posting.google.com...
> Hello,
>
> In an Oracle 8.17 database running on Sun Solaris 8, I have inherited
> the maintinance of a database that may have flaws in the commands used
> to create some Indexes and Constraints.
>
> From SQLPLus (I cannot use any GUI tools in this environment) how can
> I "unengineer" select Indexes and Constraints so as I can recreate
> and\or rewrite them to more accurately meet the business rules?
>
> Thanks,
>
> Michael

Have a look at dba_indexes, dba_ind_columns, dba_constraints, dba_cons_columns views.

--
Regards
Michel Cadot

Received on Sat Jul 31 2004 - 01:03:49 CDT