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

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. Received on Mon Aug 06 2007 - 23:37:56 CDT