ORACLE error while importing table

Posted on 2007-07-24
Last Modified: 2013-12-19
Hi, I'm trying to import a table using a DMP file into a test base but I get the following error:

Connected to: Oracle9i Enterprise Edition Release - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release - Production
Export file created by EXPORT:V09.00.01 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
export client uses WE8MSWIN1252 character set (possible charset conversion)
. importing AGRICOLA's objects into AGRICOLA
IMP-00017: following statement failed with ORACLE error 907:
IMP-00003: ORACLE error 907 encountered
ORA-00907: missing right parenthesis

After that I get a lot of errors saying the table does not exist. The table is not created at all.
Both machines are running linux (SuSE on the real server and Red Hat on the test server). What should I do?

Thanks in advance!
Question by:alcidesmaciel
    LVL 34

    Expert Comment

    by:Mark Geerlings
    The different versions of Linux are not a problem.  The different charactersets though of the import database compared to the export database could be the problem (but I'm not sure).  Do you know why those are different from each other?

    Can you drop the test database and recreate it so it uses the same chracterset as the database where the export was done?
    LVL 10

    Accepted Solution


    Please check the below link

    Possible reasons are,
    -> Different Oracle versions in source and target databases.
    -> Incompatible versions of IMP and EXP utilities.
    -> Oracle bug from


    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    XML error 2 39
    top-performance 5 91
    Oracle SQL Update Statement Query Syntax 3 47
    Oracle queries --Challenging Question 12 50
    Introduction A previously published article on Experts Exchange ("Joins in Oracle", makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
    Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
    This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
    This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now