Hi,
>>Is there anyway, we can see how many tables and rows are in dump files , without importing dump file.
Let's try to take a test ...
C:\>exp scott/tiger file=emp.dmp tables=emp statistics=none
Export: Release 10.1.0.2.0 - Production on Thu Apr 17 16:20:06 2008
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
About to export specified tables via Conventional Path ...
. . exporting table EMP 498 rows exported
Export terminated successfully without warnings.
C:\>imp scott/tiger file=emp indexfile=test.txt
Import: Release 10.1.0.2.0 - Production on Thu Apr 17 16:20:49 2008
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
Export file created by EXPORT:V10.01.00 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
. . skipping table "EMP"
Import terminated successfully without warnings.
C:\>findstr "rows" test.txt
REM ... 498 rows
Cheers
Legatti
