Re: Number of Records in Oracle Dump
Date: Tue, 12 Oct 2004 16:12:58 -0400
Message-ID: <24udnaTN0I1Fp_HcRVn-vg_at_comcast.com>
"Sybrand Bakker" <gooiditweg_at_nospam.demon.nl> wrote in message
news:328om0h5p6suujvsm2ngloagjqo1gutori_at_4ax.com...
| On 11 Oct 2004 14:13:14 -0700, mksrinath_at_indiatimes.com (Srinath M.K)
| wrote:
|
| >Hi all,
| >
| >I want to know the number of records in oracle dump without importing
| >the file. Is there a way of doing this. Your help much appriciated...
| >
| >Thanks in advance,
| >
| >Rgds,
| >Srinath M. K
|
|
| imp help=y will tell you there is the show=y option. Combine it with
| full=y and log=<any file>
|
|
| --
| Sybrand Bakker, Senior Oracle DBA
Sybrand, I thought that might do it, too, but I checked it first and found that it gives the following type of output:
"CREATE TABLE "ACCOUNT" ("BALANCE" NUMBER, "ACCOUNTNO" NUMBER) PCTFREE 10
P"
"CTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 65536 NEXT 65536
"
"MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 50 FREELISTS 1 FREELIST GROU"
"PS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM"" . . skipping table "ACCOUNT"
"GRANT SELECT ON "ACCOUNT" TO "SELECT_SCOTT"" just 'skipping table' ... no counts unless it actually processes the rows
that's with 8.1.7 (yes its old, but that's the machine I'm at now) -- but I doubt if it's changes with 9i or 10g
++ mcs Received on Tue Oct 12 2004 - 22:12:58 CEST