1 Reply Latest reply: Mar 5, 2013 12:14 PM by Dean Gagne-Oracle RSS

    Error of exportation/importation 10g to 11g R2

    user9101093
      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