1 Reply Latest reply on Jun 24, 2008 11:58 AM by GKJoe

    Issueduring verifying logical and physical dependencies of tablespaces.

    GKJoe
      I am facing below issue with Transportable Tablespace during verifying logical and physical dependencies of two tablespaces.

      Oracle 10.2.0.2.0
      RHEL 5

      [oracle@prolinoradb1 ~]$ export ORACLE_SID=prodb136
      [oracle@prolinoradb1 ~]$ sqlplus /nolog

      SQL*Plus: Release 10.2.0.2.0 - Production on Sat Oct 7 07:46:07 2006

      Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

      SQL> connect / as sysdba
      Connected.
      SQL> exec DBMS_TTS.TRANSPORT_SET_CHECK('USER_DATA_TBS,USER_NDX_TBS',TRUE);
      BEGIN DBMS_TTS.TRANSPORT_SET_CHECK('USER_DATA_TBS,USER_NDX_TBS',TRUE); END;

      *
      ERROR at line 1:
      ORA-01001: invalid cursor
      ORA-06512: at "SYS.DBMS_SYS_SQL", line 899
      ORA-06512: at "SYS.DBMS_SQL", line 19
      ORA-06512: at "SYS.DBMS_TTS", line 838
      ORA-04063: view "SYS.DBA_XML_TABLES" has errors
      ORA-06512: at "SYS.DBMS_TTS", line 867
      ORA-06512: at line 1


      SQL>


      I think some data dictionary script like catpatch.sql need to be run to resolve this issue but i didn't try it.

      Plz share your thoughts..

      Thnx
        • 1. Re: Issueduring verifying logical and physical dependencies of tablespaces.
          GKJoe
          Here i face another issue relates to transporting tablespace.

          I moved the datafiles from source db to target database (AIX 5.3 ->Windows 2003)
          Now when i tried to convert the datafile endianness to windows failing with below error...

          RMAN> CONVERT DATAFILE
          2> 'C:\tmpdir\tmpdir\tw_01.dbf',
          3> 'C:\tmpdir\tmpdir\tw_02.dbf',
          4> 'C:\tmpdir\tmpdir\tw_03.dbf',
          5> 'C:\tmpdir\tmpdir\tw_04.dbf',
          6> 'C:\tmpdir\tmpdir\tw_05.dbf',
          7> 'C:\tmpdir\tmpdir\tw_06.dbf'
          8> TO PLATFORM="Microsoft Windows IA (32-bit)"
          9> FROM PLATFORM="AIX-Based Systems (64-bit)"
          10> DB_FILE_NAME_CONVERT=
          11> "C:\tmpdir\tmpdir\", "E:\oracle\product\10.1.0\oradata\orcl\"
          12> PARALLELISM=5;

          Starting backup at 24-JUN-08
          using channel ORA_DISK_1
          using channel ORA_DISK_2
          using channel ORA_DISK_3
          using channel ORA_DISK_4
          using channel ORA_DISK_5
          RMAN-00571: ===========================================================
          RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
          RMAN-00571: ===========================================================
          RMAN-03002: failure of backup command at 06/24/2008 17:19:27
          ORA-06502: PL/SQL: numeric or value error: character string buffer too small

          Any idea?

          Source database is 10.1.0.3.0 and target database is 10.1.0.2.0. Does it matter?

          Message was edited by:
          GK Joe