# Records in dmp without doing Import [message #74216] |
Mon, 11 October 2004 15:40 |
Srinath
Messages: 40 Registered: May 2002
|
Member |
|
|
Hi all,
I would like to know the number of records in an Oracle Exported dmp file without doing an import. Kindly let me know if it is possible & how.
Thank you in advance.
Your help/suggestions much appriciated...
Srinath
|
|
|
Re: # Records in dmp without doing Import [message #74217 is a reply to message #74216] |
Tue, 12 October 2004 05:01 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
use indexfile option
bash-2.03$ imp mag/mag fromuser=mag touser=mag indexfile=somefile.sql file=expdat.dmp
Import: Release 9.2.0.4.0 - Production on Tue Oct 12 09:03:45 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
Export file created by EXPORT:V09.02.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
. . skipping table "A"
. . skipping table "DEPT"
Import terminated successfully without warnings.
bash-2.03$ cat somefile.sql
REM CREATE TABLE "MAG"."A" ("ID" VARCHAR2(30)) PCTFREE 10 PCTUSED 40
REM INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST
REM GROUPS 1) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS ;
[b]REM ... 1 rows[/b]
REM CREATE TABLE "MAG"."DEPT" ("DEPTNO" NUMBER(2, 0), "DNAME"
REM VARCHAR2(14), "LOC" VARCHAR2(13)) PCTFREE 10 PCTUSED 40 INITRANS 1
REM MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1)
REM TABLESPACE "SYSTEM" LOGGING NOCOMPRESS ;
[b]REM ... 4 rows[/b]
|
|
|