Home » RDBMS Server » Server Utilities » IMP-00003 - ORA-06550 - PLS-00103
IMP-00003 - ORA-06550 - PLS-00103 [message #225814] Wed, 21 March 2007 10:29 Go to next message
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

Re: IMP-00003 - ORA-06550 - PLS-00103 [message #226016 is a reply to message #225814] Thu, 22 March 2007 05:28 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
posting the whole metaling note is a violation of copyright. I removed the contents.
YOu can always recollect the statistics after import.
Re: IMP-00003 - ORA-06550 - PLS-00103 [message #226125 is a reply to message #226016] Thu, 22 March 2007 10:57 Go to previous messageGo to next message
gpinedo
Messages: 2
Registered: March 2007
Junior Member
OK, sorry,I didn't do it with intention.
how I recollect statistics after import?
Re: IMP-00003 - ORA-06550 - PLS-00103 [message #226155 is a reply to message #226125] Thu, 22 March 2007 12:32 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
use dbms_stats or analyze table.
Search the forum for more details
Previous Topic: export of one database and import into other database
Next Topic: DATAPUMP ORA-39152 and ORA-31696 while importing
Goto Forum:
  


Current Time: Sat Dec 10 20:34:10 CST 2016

Total time taken to generate the page: 0.14034 seconds