• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1609
  • 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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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