OraFAQ Forum: Data Integration » Data not updating dynamically in external table

Home » Developer & Programmer » Data Integration » Data not updating dynamically in external table (owb 10g, windows xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Data not updating dynamically in external table [message #277631]

Tue, 30 October 2007 23:52

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?

Report message to a moderator

Re: Data not updating dynamically in external table [message #277649 is a reply to message #277631]

Wed, 31 October 2007 01:34

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Data not updating dynamically in external table [message #277852 is a reply to message #277649]

Wed, 31 October 2007 21:09

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,

Report message to a moderator

Re: Data not updating dynamically in external table [message #295014 is a reply to message #277631]

Mon, 21 January 2008 02:43

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

Report message to a moderator

Previous Topic:	Views having Mapping Parameters Info..
Next Topic:	OWB Client doesn't start

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 14 03:59:29 CST 2025