This discussion is archived
1 Reply Latest reply: Mar 5, 2013 10:14 AM by Dean Gagne RSS

Error of exportation/importation 10g to 11g R2

user9101093 Newbie
Currently Being Moderated
Hi.

I have a data base oracle 10g (10.2.0.3). I am exporting the Schema using Grid Control 10g.

Servers:

Source:
Oracle 10.2.0.3.0

To:
Oracle RAC 11.2.0.3

I am trying to import the Schema for the server Oracle RAC 11gR2 11.2.0.3 using the Cloud Control 12c and is presenting the following error:


Error:
O job IMPORTA_EGESTAO_ESQUEMA_NOVO foi reaberto em Terca-Feira, 05 Marco, 2013 11:02
Reiniciando "SYSTEM"."IMPORTA_EGESTAO_ESQUEMA_NOVO":
Processando o tipo de objeto SCHEMA_EXPORT/USER
Processando o tipo de objeto SCHEMA_EXPORT/ROLE_GRANT
Processando o tipo de objeto SCHEMA_EXPORT/DEFAULT_ROLE
Processando o tipo de objeto SCHEMA_EXPORT/TABLESPACE_QUOTA
Execute Failed: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 18
ORA-06512: at line 44 (DBD ERROR: OCIStmtExecute)

------------------------------


Some suggestion?

Edited by: user9101093 on 05/03/2013 13:27

Edited by: user9101093 on 05/03/2013 13:52

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points