Problem with imp : no sequences imported
912609Jan 23 2012 — edited Jan 27 2012Hi,
We recently meet a problem when using export and import with Oracle 10g version 10.2.0.1.0 32 bits on a Windows plateform.
Our export full procedure is completed successfully without warning but when we try to do the import, only the tables are imported, all the sequences are missing.
In the log, we can find the following error messages :
IMP-00032: L'instruction SQL dépasse la longueur du tampon d'enregistrement (sql instruction over record buffer length)
IMP-00008: instruction non reconnue dans le fichier d'export: (instruction no recognized in the export file)
STORAGE(INITIAL 65536 FREELISTS 4 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSAUX" LOGGING NOCOMPRESS
We also get some IMP-00041 on the triggers because the sequences are missing
Our exp commande-line :
exp system@noviprod full=y grants=y statistics=none consistent=Y file=%1\sauvegarde\production\oracle\exp\%2.dmp log=%1\sauvegarde\production\oracle\log\explog.log
Our imp command-line :
imp system/system@caria log=c:\import_cari\log_import_dsi.txt analyze=no fromuser=dsi touser=dsi file=c:\import_cari\import.dmp full=N buffer=1000000
Why are the sequences not imported ?
We've already tried to increase the buffer parameter or to remove it, but it didn't solve the problem.
We've never been facing such a problem.
Thank you for your assistance,
Best regards,
Matthieu KREMBEL
Gip symaris