Re: Extracting DDL from Oracle

From: John Leggitt <johnml_at_istar.ca>
Date: 1998/03/31
Message-ID: <7$$T.65$U55.885430@NewsRead.Toronto.iSTAR.net>#1/1

Check the data dictionary: user_indexes and user_ind_columns. Do a select from each to view details.
There are many other details that can be found in the data dictionary. Do a SELECT * FROM dict to get a listing of views available to you. JohnL

Steve Faull wrote in message <6foosg$4kr$1_at_usenet48.supernews.com>...
>Hello,
>
>I'm kinda new to Oracle DBA land and have what might be a basic question.
>Anyway, I was wonding if there's some sort of select statement or
something
>that would extract DDL statements for objects stored in the given database.
>Spacifically, I want to extract all the DDL for all the indexes in a given
>tablespace. Is this even possible? Any help would be greatly appreciated.
>
>Thanks in advance,
>
>-Steve
>
>
Received on Tue Mar 31 1998 - 00:00:00 CST