Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to export schema..

The_RockSep 7 2017 — edited Sep 9 2017

I am using Oracle

C:\Users\Administrator>exp

Export: Release 11.2.0.1.0 - Production on Thu Sep 7 15:15:18 2017

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Username: erp

Password:

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit

Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Enter array fetch buffer size: 4096 >

Export file: EXPDAT.DMP > D:\erp_backup.dmp

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

Export grants (yes/no): yes >

Export table data (yes/no): yes >

Compress extents (yes/no): yes >

Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

EXP-00002: error in writing to export file

EXP-00000: Export terminated unsuccessfully

C:\Users\Administrator>

C:\Users\Administrator>exp erpl\1234 file=d:\erp_backup.dmp log=d:\erp_backup.log

Export: Release 11.2.0.1.0 - Production on Thu Sep 7 15:18:21 2017

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Password:

EXP-00056: ORACLE error 1017 encountered

ORA-01017: invalid username/password; logon denied

Username: erp

Password:

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

EXP-00002: error in writing to export file

EXP-00000: Export terminated unsuccessfully

C:\Users\Administrator>

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 7 2017
Added on Sep 7 2017
10 comments
410 views