Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: imp - how to get a listing of an export file...?

Re: imp - how to get a listing of an export file...?

From: <fitzjarrell_at_cox.net>
Date: 1 Nov 2005 14:00:18 -0800
Message-ID: <1130882418.181421.117940@g44g2000cwa.googlegroups.com>

Mark D Powell wrote:
> Instead of using SHOW the INDEXFILE option might prove useful to Tommy.
> It will generate all the DDL to a file. Everything but the create
> indexes will be commented out but Tommy may find the results more
> readable.
>
> HTH -- Mark D Powell --

The indexfile parameter generates only create table, create index and alter table statements; no additional DDL is available, such as packages, procedures,functions or triggers. If he needs the entire schema DDL only the show=y option will work.

David Fitzjarrell Received on Tue Nov 01 2005 - 16:00:18 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US