Forgot your password?    
+ Reply to Thread
Results 1 to 1 of 1

Thread: Prob & Sol of Exp/Imp Utility

  1. #1

    Prob & Sol of Exp/Imp Utility

    Note:--Real Prob. in My Testing Development Server:-

    When I was exporting of my Development database(Oracle 10g R2),then some errors are occurred.
    Srcipt is given as:--Script's name (exp1.sh).........

    exp userid=<usernm>/<passwd> file=exp_sixmnth.dmp buffer=10000000 compress=y tables='<tab1>','<tab2>',....'<tabn>'
    query=\"where sb_dt\>to_date\(\'01-may-2011\',\'dd-mon-yyyy\'\)\" rows='Y' log=exp_sixmnth.log

    $exp1.sh

    Export: Release 10.2.0.5.0 - Production on Fri Jan 20 10:05:30 2012

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

    Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bitn
    With the Partitioning, OLAP, Data Mining and Real Application Testing options

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

    About to export specified tables via Conventional Path ...
    EXP-00008: ORACLE error 1406 encountered
    ORA-01406: fetched column value was truncated
    EXP-00000: Export terminated unsuccessfully



    Solution of the Problem:--(You can choose any solution)
    Solution 01:
    Change the Database character set to AL32UTF8 will solve this problem.

    Solution 02:
    Apply Patch for BUG 6804150 if available for your platform.

    Solution 03:
    Install the Oracle 10.2.0.5 patchset.

    Solution 04:
    Use 11g exp client utility.



    Common Problems:--


    ORA-01555: Snapshot too old

    Sol:--STOP working while you are exporting or use parameter CONSISTENT=NO. It means that the parameter consistent=Y is replaced by consistent=N.



    ORA-01562: Failed to extend rollback segment,

    Sol:- Create bigger rollback segments or set parameter COMMIT=Y , with an appropriate BUFFER parameter while importing.


    IMP-00015: Statement failed ........object already exists.

    Sol:-- Use the IGNORE=Y import parameter to ignore these errors.
    Last edited by vineettyagi; 01-21-2012 at 12:22 PM.

+ Reply to Thread

Similar Threads

  1. Offline/Online Database Verification Utility
    By devesh_ocp in forum Backup, Restoration & Recovery, RMAN, Flashback, Datapump, Export, Import
    Replies: 0
    Last Post: 04-24-2012, 10:48 PM
  2. Changing the DBID - DBNEWID utility
    By Sandeep Sharma in forum Core Database Administration and Monitoring
    Replies: 4
    Last Post: 04-11-2012, 01:07 PM
  3. Logical Backup for Oracle Databse using export and import Utility
    By vineettyagi in forum Backup, Restoration & Recovery, RMAN, Flashback, Datapump, Export, Import
    Replies: 0
    Last Post: 01-18-2012, 05:36 PM
  4. how to autamate task by using cron utility
    By nemat in forum OS for Oracle Administration
    Replies: 0
    Last Post: 01-14-2012, 01:59 AM
  5. adadmin Utility
    By Hemant in forum AD Utilities , Autoconfig , FND Utilities
    Replies: 0
    Last Post: 10-30-2011, 03:46 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics