Export Errors
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Export Errors

  1. #1
    Join Date
    Jan 2002
    Posts
    65
    Hi All,

    I have an Oracle 7.3.4 server from where I am trying to export an user as follows.

    C:\>exp73 orgsmgr/orgsmgr file=DB_USER.DMP compress=no grants=yes owner=orgsmgr
    file=DBUSER.DMP log=DBUSER.log

    But while doing so I am getting EXP-00008 and ORA-01003 for all the objects.

    What can be the possible reason??
    Can any one throw some light on this.



    Sabitabrata

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Originally posted by sabita_ban

    C:\>exp73 orgsmgr/orgsmgr file=DB_USER.DMP compress=no grants=yes owner=orgsmgr
    file=DBUSER.DMP log=DBUSER.log
    You are using 'file=' twice in your command line ? ?

    Check that out.

  3. #3
    Join Date
    Jan 2002
    Posts
    65

    Unhappy

    I have Rectified this..thanks
    But even then getting the same problem
    Sabitabrata

  4. #4
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    are you sure you are using the correct executable ?

    Did you ever run the catexp script ?

    Normally this error appears when we run an exp-executable against a rdbms that's not the same version as the exp.
    metalink note : 106155.1

    Hope this helps
    Gert

  5. #5
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    you can also take a look at metalink not : Note:175624.1
    a FAQ on export-import

    Gert

  6. #6
    Join Date
    Jan 2002
    Posts
    65
    Thanks all of you,

    Running catexp.sql did the trick...
    Now no errors encountered during Export

    Can some one elaborate as to what for is this script actually required.

    I found out that this script
    creates the necessary export views,
    assigns all necessary privileges to the EXP_FULL_DATABASE role,assigns EXP_FULL_DATABASE to the DBA role

    But what has this to do with ORA-01003 error?? Which says

    ORA-01003 no statement parsed

    Copyright (C) 1995, Oracle Corporation
    A host language program call referenced a cursor with no associated parsed SQL statement. A SQL call (for example, OSQL3) must be used to pass a SQL statement to Oracle and to associate the statement with an open cursor. A cursor must already have an associated SQL statement if referenced in any of the following calls: DESCRIBE, NAME, DEFINE, BIND, EXECUTE,and FETCH.


    Copyright (C) 1995, Oracle Corporation


    Thanks in advance
    Sabitabrata
    Sabitabrata

  7. #7
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    Export utility uses few views and procedures. Without having them how can Oracle do the process?? So, we have to create them. That's what you did by running catexp.sql.
    -nagarjuna

  8. #8
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    I saw problem like this. Probably this bug in exp/imp parser.

    sitation was following:

    if in CREATE TABLE statment was line -->
    abc date default SYSDATE ,
    bcd ... )
    or
    usr varchar2(30) default user ,
    aaa ... )
    all was OK

    but if was:

    abc date default SYSDATE )
    or
    usr varchar2(30) default user )

    export utility issued error ORA-01003 .
    different was only ) or , has been wrote after .. DEFAULT + function name without ().

    Check does any table has text like this.

Posting Permissions

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


Click Here to Expand Forum to Full Width