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

Home -> Community -> Usenet -> c.d.o.server -> want to find out the Tables and Tablespaces info without importing the export dump file?

From: Krish <Krishna.Bussu_at_gmail.com>
Date: Tue, 07 Aug 2007 04:06:25 -0000
Message-ID: <1186459585.061796.47510@d55g2000hsg.googlegroups.com>

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.

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.

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.

Thanks,
Krish Received on Mon Aug 06 2007 - 23:06:25 CDT