problem regarding import

[dasdeba]

Hallo raydp, Julian,

case 1 : We do export and import every night . It continued for last 2 years . Suddenly after changing the archive mode of the database , when I am trying to import that dmp file in another database it is giving error IMP-0008 .This method we have been using for the last 2 years. If we export and import the scott user then it is running fine , but in case of other users ( which are actually needed ) the error is coming.

First of all I want to say that we take user level export , then compress it through a pipe , then file transfer is made using binary ftp , then we run user level import. there is no chance of hard disk getting full ( 32% disk is free ) also. The system Oracle 7.3.4 on SCO unix 5.0.5 . We thought file might be corrupted. But we have checked that file is not corrupted
using SUM command . Now What to do ?

[sambavan]

Could you tell us more on the error you get? Error log would be good


Sam

[sambavan]

Ref: http://www.dbasupport.com/forums/sho...threadid=16785

Sam