Import error

[Jesu]

Hi all,

I am Jesu, I got the below error while importing (oracle 8i windows
2000 server)

Can any one help me to resolve it.

IMP-00017: following statement failed with ORACLE error 6550:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL :=
'41444D494E495354524"
"1544F523A303730383033313130323237'; SREC.MAXVAL :=
'475241463A3037303330333"
"13435333138'; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS :=
DBMS_STAT"

"S.NUMARRAY(338884622913374000000000000000000000,370321406108332000000000000"
"000000000); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2;
DBMS_ST"
"ATS.SET_COLUMN_STATS(NULL,'"PLAN_TABLE"','"STATEMENT_ID"', NULL
,NULL,NULL,"
"94,,0106382978723404,0,srec,23,0); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 454:
PLS-00103: Encountered the symbol "," when expecting one of the
following:

Thanks in advance
Jesu.

[Jesu]

[fitzj...@cox.net]

For what you've posted the manuals at tahiti.oracle.com would be as
much use as anyone here. You provide no source database version for
this export, you provide no full release number for the destination.
How on earth can you expect anyone to help you when you won't provide
sufficient information? Double-posting does NOT constitute 'more
information'.

Post at least what has been asked. Possibly then someone may be able
to assist you.

David Fitzjarrell

[Mohan Reddy]

Hi,

 

In this case your tablespace is not in autoextend mode. You have to increse the tablespace size.

 

alter tablespace tbs

add datafile 'c:\abcdorcl.ora' size 250M;

 

Thanks,

 

 

Mohan Reddy G

 

[fitzj...@cox.net]

> --
> Mohan Reddy
> Oracle DBA
>

Explain how a PL/SQL compilation error indicates the tablespace cannot
autoextend:

IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 454:
PLS-00103: Encountered the symbol "," when expecting one of the
following:

ORA-06550: line string, column string: string
Cause: Usually a PL/SQL compilation error.
Action: none

I think you need to go back to DBA101.

David Fitzjarrell

[Madhu]

I have seen similar errors below almost at the end of IMPORT..
Sometimes compiling the invalid objects is the FIX... try to run
$ORACLE_HOME/rdbms/admin/utlrp.sql on the database and query the
database to make sure you do not have any invalid objects. If you have
still invalid objects in the database(particularly application
schemas), then you must need to look at the PL/SQL code to identify the
problem.

regards,
Madhu

[Jesu]

Thanks a LOT.
I have increased the Table space and reimported. It works. thanks a lot