1 Reply Latest reply: Dec 27, 2013 12:48 AM by Shankar S. RSS

Specifying a tablespace when creating AW

user703537 Newbie
Currently Being Moderated

Hello,

 

When creating in analytic workspace using the workspace manager, it asks for the tablespace name which is entered by the developer. But in the customer's instance, when they will create the analytic workspace using import_xml as suggested in this forum earlier using DBMS_CUBE.IMPORT_XML, how can the tablespace name be speficied? The tablespace names in customer's instance could vary. Would appreciate your suggestions.

 

Thanks,

Satyadeep.

  • 1. Re: Specifying a tablespace when creating AW
    Shankar S. Journeyer
    Currently Being Moderated

    I faced the same issue sometime back and found the solution with help of OLAP Dev team.

     

    Solution:

    In your AWXML template, there is a <AW> tag which can be used to specify the Tablespace Name detail.

    Edit the attribute "TablespaceName" within <AW> Tag as needed and distribute/build :-)

     

    E.g:

    ...

      <AW

        Name="AW_NAME"

        TablespaceName="OLAP_TBS"

        Version="11.2">

      </AW>

    ...

Legend

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