Home » RDBMS Server » Server Utilities » export fails (export fails )
export fails [message #537953] Tue, 03 January 2012 03:34 Go to next message
hemant_khandare
Messages: 72
Registered: November 2011
Member
I am trying to take backup of the user tstcvs of cvmdb database but it fails due to some reason ,kindly help.
[oracle@cvs ~]$ exp

Export: Release 10.2.0.1.0 - Production on Tue Jan 3 12:37:06 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Username: sys/sysdba@cvsdbm as sysdba

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Enter array fetch buffer size: 4096 >

Export file: expdat.dmp > 3-1-12-tstcvs

(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > 2

Export grants (yes/no): yes >

Export table data (yes/no): yes >

Compress extents (yes/no): yes >

Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)

About to export specified users ...
User to be exported: (RETURN to quit) > tstcvs

User to be exported: (RETURN to quit) >

. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user TSTCVS
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user TSTCVS
About to export TSTCVS's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export TSTCVS's tables via Conventional Path ...
. . exporting table AAA 0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table ABM_BILL 7411930 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table ABM_BILL3 7411930 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table ABM_BILL_DETAIL 69035749 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table ABM_BILL_DETAIL3 69035749 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table ABM_BILL_PENALTIES 7105255 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table ABM_BILL_PENALTIES3 7105255 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table ABM_CAPVAL_FLAT_DB4 2347825 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table ABM_CAPVAL_FLAT_DB4_03062011 2322048 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table ABM_CAPVAL_FLAT_DB4_13062011 2347825 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table ABM_CAPVAL_FLAT_DB4_BK 2347825 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table ABM_CAPVAL_FLAT_DB4_DM 0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table ABM_CAPVAL_FLAT_MASTER 17237 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table ABM_CAPVAL_FLAT_MASTER_0_SPL 14475 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table ABM_CAPVAL_FLAT_MASTER_BK 16502 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table ABM_CAPVAL_PROP_DB3_03062011 238833 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table ABM_CAPVAL_PROP_DB3_13062011 239749 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table ABM_CAPVAL_PROP_MASTER 0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table ABM_CAPVAL_PROP_MASTER_0_SPL 7022 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table ABM_CAPVAL_PROP_MASTER_DB3 239750 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table ABM_CAPVAL_PROP_MASTER_DB3_BK 239750 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table ABM_CAPVAL_PROP_MASTER_DB3_DM 0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table ABM_CAPVAL_PROP_MASTER_JYOTI 7678 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table ABM_CITIZEN 1139042 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table ABM_CITIZEN_DETAIL 1139042 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table ABM_CV_FLOOR_FACTOR_NEW 217 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table ABM_CV_FLOOR_MASTER 216 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table ABM_CV_USER_CATAGORY_LU_1204 23 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table ABM_DESIGNATION 4 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table ABM_FLAT 88019 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table ABM_FLAT3 88005 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table ABM_HISTORY_FLAT_DETAIL 0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table ABM_HISTORY_PROP_DETAIL 0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table ABM_PROPERTY 391762 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table ABM_PROPERTY1 381686 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table ABM_PROPERTY3
EXP-00002: error in writing to export file
EXP-00002: error in writing to export file
EXP-00000: Export terminated unsuccessfully
[oracle@cvs ~]$

[Updated on: Tue, 03 January 2012 03:40] by Moderator

Report message to a moderator

Re: export fails [message #537958 is a reply to message #537953] Tue, 03 January 2012 03:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
I am trying to take backup of the user tstcvs of cvmdb database

No, you took a dump of your data (or tried to).

Use the option "statistics=none".

Regards
Michel
Re: export fails [message #537994 is a reply to message #537953] Tue, 03 January 2012 06:27 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>EXP-00002: error in writing to export file
Also please check if there is enough diskspace.
Re: export fails [message #538000 is a reply to message #537953] Tue, 03 January 2012 07:33 Go to previous messageGo to next message
John Watson
Messages: 8962
Registered: January 2010
Location: Global Village
Senior Member
I would use the option resumable=y so that if you get space related errors you can fix them and the export will continue, and the option consistent=y to improve the likelihood that the dump will actually be useful.
Re: export fails [message #538003 is a reply to message #538000] Tue, 03 January 2012 07:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
if you get space related errors you can fix them and the export will continue

Even for OS space error?

Regards
Michel
Re: export fails [message #538008 is a reply to message #538003] Tue, 03 January 2012 08:04 Go to previous messageGo to next message
John Watson
Messages: 8962
Registered: January 2010
Location: Global Village
Senior Member
I remember testing with Data Pump, and I think it worked. I can't remember if I tested exp. It will take a while to check (I'll have to create a little file system, and fill it up) but if I do, I'll report back.
Re: export fails [message #538016 is a reply to message #538008] Tue, 03 January 2012 08:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
OK, thanks.

Regards
Michel
Re: export fails [message #538166 is a reply to message #538016] Wed, 04 January 2012 08:48 Go to previous message
hemant_khandare
Messages: 72
Registered: November 2011
Member
thanks a lot your reply helped me to get out of this rid ,actually it is due to low memory on database server.
Previous Topic: Import dump file without 2 tables
Next Topic: Flat file Tab Delimeter import Messed up with SQL Loader !!
Goto Forum:
  


Current Time: Mon Dec 23 06:35:38 CST 2024