Home » RDBMS Server » Server Utilities » # Records in dmp without doing Import
# Records in dmp without doing Import [message #74216] Mon, 11 October 2004 15:40 Go to next message
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 Go to previous message
Mahesh Rajendran
Messages: 10707
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]

Previous Topic: export/import specific users and roles
Next Topic: Sybase versus Oracle
Goto Forum:
  


Current Time: Mon Jul 01 08:51:57 CDT 2024