Oracle Migration Error from 4.6c/oracle9i/solaris to 4.6c/oracle10g/HPUX11.

[Former Member]

Dear all,

We are starting the first round of migration using HPSTM (Migration Tool). The O2O generated all the scripts based on following parameters:

Crs.sql

exec reorg.reorg_start(ACT_KEY=>'23227656440516794127',OPT=>TRUE,db_link=>'R3S_OLD',SAPDATA=>9,CHECK_LR=>TRUE,SID=>'DV2'

,SCHEMA=>'SAPR3',db_file_size=>9000,max_size=>500,max_tabs=>400,TEMP_SPACE=>9000,REXP=>FALSE,UNDO_SIZE=>3000,V10G=>TRUE,

TRANS=>TRUE,PW=>'H0!ysh1t',PW_SYSTEM=>'r3smanager');

When we ran the scripts, TblCopy, exp, imp and ind scripts are working fine. However, all the ctas scripts failed. All the errors are like these:

cpchpsap:oradv2 105> more SAPR3_ctas_ZTV7ORD_071209_122217.log

SQL> WHENEVER SQLERROR EXIT 1

SQL> WHENEVER OSERROR EXIT 2

SQL> REM Creating Table ZTV_ORD

SQL> CREATE TABLE "SAPR3"."ZTV_ORD"

2 TABLESPACE PSAPBTABD

3 STORAGE (INITIAL 256M)

4 NOLOGGING

5 AS SELECT * FROM "SAPR3"."ZTV_ORD"@R3S_OLD

6 ;

AS SELECT * FROM "SAPR3"."ZTV_ORD"@R3S_OLD

*

ERROR at line 5:

ORA-00604: error occurred at recursive SQL level 1

ORA-01653: unable to extend table SYS.AUD$ by 12137 in tablespace SYSTEM

ORA-02002: error while writing to audit trail

ORA-00604: error occurred at recursive SQL level 1

ORA-01653: unable to extend table SYS.AUD$ by 12137 in tablespace SYSTEM

ORA-02063: preceding 5 lines from R3S_OLD

Can you help me take a look at it?

Thanks

Senthil

[Former Member]

Set the AUDIT_TRAIL parameter in the initialization parameter file in the following way:

AUDIT_TRAIL = NONE

[Former Member]

I'm not export on HPSTM, but error looks like SYSTEM tablespace is full.

Check tablespace.

-Pinkle

[Former Member]

This issue is solved.

Just

Set the AUDIT_TRAIL parameter in the initialization parameter file in the following way:

AUDIT_TRAIL = NONE

and it will be alright

Regards

Senthil