Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem with imp : no sequences imported

912609Jan 23 2012 — edited Jan 27 2012

Hi,

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