Re: want to find out the Tables and Tablespaces info without importing the export dump file?

On Aug 7, 6:37 am, Noons <wizofo..._at_yahoo.com.au> wrote:
> On Aug 7, 2:06 pm, Krish <Krishna.Bu..._at_gmail.com> wrote:
>
> > Hi,
>
> > We use EXP/IMP utilities most of the time to move the data across
> > databases. We are spending lot of time to compare the tables in the
> > dump files and tables actually imported ( if import fails in the
> > middle). Also import fails sometimes with the error "Tablespace xxx
> > doesn't exist.
>
> > Is there any GUI tool to list out all the tables that are in the Dump
> > file.
>
> you don't need one. imp has a special flag to list
> the contents of the ddl in the export file. That and a
> text editor is all you need. Of course, you can use a
> GUI text editor!
>
> > Also would like to find what all the tablespaces need to create before
> > importing the actual dump file (to avoid errors "Tablespace xxx
> > doesn't exist.
>
> As above.
>
> > I worked with this kind of tool long ago for the same purpose. Just
> > wanted to check if anyone out there is using such tool.
>
> never seen one, mostly because I never needed one: the
> list contents switch does it all.

This is why i don't like GUI tool they makes people lazy. If you make "imp" with indexfile parameter it generates a text file with all informations you need.

regards,

Cristian Cudizio
http://oracledb.wordpress.com
http://cristiancudizio.wordpress.com Received on Tue Aug 07 2007 - 03:28:50 CDT