• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1641
  • Last Modified:

ORACLE error while importing table

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 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - 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:
 " ALTER TABLE "PARAMETROSAGRICOLA" MODIFY ("ENCERRA_TALHAO_FINALIZA_SAFRA" D"
 "EFAULT 'N'"
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!
0
alcidesmaciel
Asked:
alcidesmaciel
1 Solution
 
Mark GeerlingsDatabase AdministratorCommented:
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?
0
 
ravindran_eeeCommented:
Hi,

Please check the below link

http://forums.oracle.com/forums/thread.jspa?threadID=514015&start=15&tstart=-1

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

Regards,
Ravindran
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now