Home > Default > Export table does not match no. of rows

Export table does not match no. of rows

November 30Hits:0
Advertisement
Tried to export one table from a database and it does not capture all rows. Here's a snapshot from the export and select statement:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
SQL> select count(*) from user1.domain;
COUNT(*)
1342
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
C:\exp user1/[email protected] tables=DOMAIN full=n file=c:\domain.dmp log=c:\domain.log rows=y indexes=n
Export: Release 10.2.0.3.0 - Production on Fri May 21 10:04:10 2010
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
Note: indexes on tables will not be exported
About to export specified tables via Conventional Path ...
. . exporting table ALNDOMAIN 1338 rows exported
Export terminated successfully without warnings.

Answers

SQL> select count(*) from user1.domain;
COUNT(*)-- selecting from table user1.domain
About to export specified tables via Conventional Path ...
. . exporting table ALNDOMAIN 1338 rows exported-- exporting table ALNDOMAIN
They seem different tables.
Try:
exp user1/[email protected] tables=user1.domain file=c:\domain.dmp log=c:\domain.log rows=y indexes=nHTH

Read other 9 answers

Tags:

Related Articles

  • Export table does not match no. of rowsNovember 30

    Tried to export one table from a database and it does not capture all rows. Here's a snapshot from the export and select statement: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production SQL> select count(*) from user1.domain; COUNT(*

  • EXP 11.2.0.1 export tables with at leat 1 rowNovember 30

    I have oracle db 11.2.0.1 and user the export utility to export tables, and row dati from the database to a file dmp. I have notice that mow it extract the table with at leat 1 row and do not export table empty and so when i execute an import i lost

  • Need help to create export table procedureOctober 11

    Hi, I have created a procedure, which may use to do following things: 1. first create a duplicate table of sys.aud$ records 2. export that duplicate table here I am enclosing my code: 1. create or replace procedure crt_tab 2. is 3. sqlstring varchar2

  • Update row in a table based on join on multiple rows in another tableOctober 11

    I am using SQL Server 2005. I have the following update query which is not working as desired. UPDATE DocPlant SET DocHistory = DocHistory + CONVERT(VARCHAR(20), PA.ActionDate, 100) + ' - ' + PA.ActionLog + '. ' FROM PlantDoc PD INNER JOIN PlantActio

  • How can we export table data to a CSV file??October 11

    Hi, I have the following requirement. Initially business agreed upon, exporting the table data to Excel file. But now, they would like to export the table data to a CSV file, which is not being supported by af:exportCollectionActionListener component

  • Cartesian of data from two tables with no matching columnsOctober 11

    Hello, I was wondering – what's the best way to create a Cartesian of data from two tables with no matching columns in such a way, so that there will be only a single SQL query generated? I am thinking about something like: for $COUNTRY in ns0: COUNT

  • View table and Master table don't matchOctober 11

    I am setting up Materialize view replication between two systems connected over a WAN. The number of rows in the master table does not match the number of rows in the Table at the view site. Is there a way I can monitor/watch or otherwise see what re

  • Is it possible to export tables from diffrent schema using expdp?November 30

    Hi, We can export tables from different schema using exp. Ex: exp user/pass file=sample.dmp log=sample.log tables=scott.dept,system.sales ...But Is it possible in expdp? Thanks in advance .. Thanks,Hi, you have to use "schemas=user1,user2 include=tab

  • Export Table in Oracle 9iNovember 30

    Hi, I have created a clone database using cold backup from my production DB. when i run export command, it gives following error... C:\>EXP devuser/[email protected] file=D:\Event.dmp log=eventexp.log tables=event rows=yes grants=y constraints=y consist

  • Report crashes when table having lots of columns and rows, please helpNovember 30

    Hi, Everyone, Our system is Apex 4.0.2 with Oracle 11GR2 and Oracle HTTP server in the middle. We have a very simple report drawing data from a table with 46 columns ( no binary data) , when the maximun rows is 500, everything is fine; but if I incre

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.317 s.