1 Reply Latest reply: Aug 14, 2014 2:36 AM by 2720685 RSS

    Setting version in LKM oracle to oracle (datapump)

    2720685

      create table <%=odiRef.getTable( "COLL_NAME")%>

       

       

      (

        <%=odiRef.getColList("", "[CX_COL_NAME]", ",\n\t", "", "")%>

      )

      ORGANIZATION EXTERNAL (

        TYPE oracle_datapump

        DEFAULT DIRECTORY <%=odiRef.getOption("X_DATAPUMP_ORACLE_DIR")%>

        LOCATION ('<%=odiRef.getOption("X_DATAPUMP_NAME")%>.dmp')

      )

      PARALLEL

      as SELECT <%=odiRef.getPop("DISTINCT_ROWS")%>

        <%=odiRef.getColList("", "[EXPRESSION]", ",\n\t", "", "")%>

      from <%=odiRef.getFrom()%>

      where (1=1)

      <%=odiRef.getFilter()%>

      <%=odiRef.getJrnFilter()%>

      <%=odiRef.getJoin()%>

      <%=odiRef.getGrpBy()%>

      <%=odiRef.getHaving()%>

       

       

      I have this code, which works, to generate a datapump file. However I need to specify to make it version 10.2 compatible.

       

      I have tried placing VERSION 10.2 / VERSION=10.2 / VERSION '10.2' / VERSION='10.2' / ... almost everywhere and I can't seem to find the correct spot because I keep getting errors.

       

      To me this seems like a dumb question which I hope gets resolved easily but where do I put the correct statement?

       

      Thanks!

        • 1. Re: Setting version in LKM oracle to oracle (datapump)
          2720685

          Found the issue:

           

          create table <%=odiRef.getTable( "COLL_NAME")%>

          (

            <%=odiRef.getColList("", "[CX_COL_NAME]", ",\n\t", "", "")%>

          )

          ORGANIZATION EXTERNAL (

            TYPE oracle_datapump

            DEFAULT DIRECTORY <%=odiRef.getOption("X_DATAPUMP_ORACLE_DIR")%>

            ACCESS PARAMETERS (

            VERSION '10.2'

            NOLOGFILE

            )

            LOCATION ('<%=odiRef.getOption("X_DATAPUMP_NAME")%>')

          )

          PARALLEL

          as SELECT <%=odiRef.getPop("DISTINCT_ROWS")%>

            <%=odiRef.getColList("", "[EXPRESSION]", ",\n\t", "", "")%>

          from <%=odiRef.getFrom()%>

          where (1=1)

          <%=odiRef.getFilter()%>

          <%=odiRef.getJrnFilter()%>

          <%=odiRef.getJoin()%>

          <%=odiRef.getGrpBy()%>

          <%=odiRef.getHaving()%>