5 Replies Latest reply: Feb 16, 2013 11:27 PM by RR RSS

    ORA-00942: table or view does not exist - OWB

    RR
      Hi all,

      I am using Oracle warehouse bulider for ETL process.

      I have created Source and target. Targer schema in local database and source schema in different database.

      In mapping deployement its throws an error like

      ORA-06550: PACKAGE BODY, line 28, column 12:
      PL/SQL: ORA-00942: table or view does not exist

      Help me regarding this.
        • 1. Re: ORA-00942: table or view does not exist - OWB
          mcoene
          are your grants in the database set up correctly?
          • 2. Re: ORA-00942: table or view does not exist - OWB
            RR
            thanks,

            Source datasource xxx/yyy and target data source aaa/bbb.

            In deployement path i am getting error like ORA-00942: table or view does not exist.

            How to give privellage to target schema?

            source and taget have different data base.

            Help me regarding this.
            • 3. Re: ORA-00942: table or view does not exist - OWB
              496810
              Create a dynamic sql script that grants to all tables in source to target..

              something like

              grant select on ||table_name|| to target_schema.
              • 4. Re: ORA-00942: table or view does not exist - OWB
                user8950278
                Hi,

                don't know if your problem is solved.

                But if not, if you want to use a table from a different database you have to create a new module (e.g. MOD_1) which is pointing to the database and the schema, for e.g Source datasource xxx/yyy .
                OWB creates a location with the needed informations. You should find them under Locations Navigator --> Locations --> Databases --> Oracle

                Import your table you want to use in a mapping in this module (via design center).

                Now you can create a mapping in your Module (e.g. MOD_2) which is pointing to target data source aaa/bbb.

                Here you can drag and drop the table to the mapping designer.

                When you deploy the Mapping owb will create a dblink. This dblink can be found under the location which belongs to MOD_2 (DB Connectors).

                Hope this helps.

                Greetings
                • 5. Re: ORA-00942: table or view does not exist - OWB
                  RR
                  Thanks.

                  I missed to set data location for the source schema. I found this from mapping scripts.

                  Edit our source module and check metadata location and data locations.

                  Move ur source location from Available locations to selected locations.