| IMP-00003 - ORA-06550 - PLS-00103 [message #225814] |
Wed, 21 March 2007 10:29  |
gpinedo
Messages: 2
Registered: March 2007
|
Junior Member |
|
|
Hi! I need aid about a IMPORT.
I must change of server a base 8i, thus:
1) I Run a EXPORT full:
:EXPORT
c:\Oracle8i\BIN\EXP system/*****@ba FULL=Y FILE=d:\backup\ba_exp.dmp LOG=d:\backup\ba_exp.log DIRECT=Y
2) I generate the instance in the new server
3) I run a IMPORT Full:
set oracle_sid=ora
IMP system/******* FULL=Y FILE=d:\backup\ba_exp.dmp LOG=d:\backu\ba_imp_log.log
And it gives the following error me:
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 388:
PLS-00103: Encountered the symbol "," when expecting one of the following:
According to metalink:
{Metalink contents removed}
5) Then, I erase all the tables that were gotten to create in import and I return it to execute, but with ANALYZE=N and IGNORE=Y:
set oracle_sid=ora
IMP system/******* FULL=Y ANALYZE=N IGNORE=Y FILE=d:\backup\ba_exp.dmp LOG=d:\backu\ba_imp_log.log
This way: "Import terminated successfully without warnings."
As in export by defect STATISTICS = ESTIMATE, what implies that IMPORT does not analyze the statistics (IMP system/******* FULL=Y ANALYZE=N)? I can have problems if I do it of that form? if it is thus, what kind of problems I can have?
I hope that me somebody can help me,
Thanks,
Gabriela
[Updated on: Wed, 21 March 2007 17:00] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
