Home » Developer & Programmer » Data Integration » Data not updating dynamically in external table (owb 10g, windows xp)
Data not updating dynamically in external table [message #277631] Tue, 30 October 2007 23:52 Go to next message
mbhkr5
Messages: 20
Registered: October 2007
Junior Member
Hi,

I have created an external table for .csvfile( which is my source file ,,,excel)..I used this external file as my source in a mapping...Mapping is executing fine if both mapping and external file are in same module....The problem comes when i'm updating .csv file...external tableis not updating ...Please help me out in this regard..

And one more problem..if external table and my mapping are in two different modules...it's showing error while deploying the mapping ..as

ORA-06550: line 203, column 13:
PL/SQL: ORA-00942: table or view does not exist

what might be the problem?

Re: Data not updating dynamically in external table [message #277649 is a reply to message #277631] Wed, 31 October 2007 01:34 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Are you sure external tables can be updated? SQL UPDATE statement will fail:
SQL> update ext_table set datum = sysdate;
update ext_table set datum = sysdate
       *
ERROR at line 1:
ORA-30657: operation not supported on external organized table
Does Warehouse Builder work differently?

Because Documentation says
Quote:

Oracle Database allows you read-only access to data in external tables.
Re: Data not updating dynamically in external table [message #277852 is a reply to message #277649] Wed, 31 October 2007 21:09 Go to previous messageGo to next message
mbhkr5
Messages: 20
Registered: October 2007
Junior Member
Actually, I'm not trying to update external table directly...If I change .csv file which is the flat file for the external table created...external table should update....

But, it did not work yesterday...Now, it's ok,,,it's updating...


And what about my second problem...
i.e.In same project I created to modules, say, one for staging area and another for target..
I created a external table under staging module..and using it as source in one of the mapping, in target module. When I validate it's ok..But, when I try to deploy the mapping, it's saying as

ORA-06550: line 203, column 13:
PL/SQL: ORA-00942: table or view does not exist

Help me out in this regard,

Re: Data not updating dynamically in external table [message #295014 is a reply to message #277631] Mon, 21 January 2008 02:43 Go to previous message
sunilgond
Messages: 35
Registered: January 2008
Location: INDIA
Member

Hi

Is there are different Schema for your two different modules.
Then in this case you have to give grant permission from ur schama(where table exist) to another schama(in which schema u want to use your table);

Syntax : GRANT ALL ON <TABLE_NAME> TO <SCHEMA_NAME>


Sunil Kumar Gond
Satyam Computer Services Ltd.
+919912125600
Previous Topic: Views having Mapping Parameters Info..
Next Topic: OWB Client doesn't start
Goto Forum:
  


Current Time: Thu Mar 28 12:49:19 CDT 2024