Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Extracting the data

267703Aug 12 2004 — edited Aug 13 2004

Hi Mark,
My objective is to extract data from a table and write to a flat file. I have created a source which is from Oracle Database 9i(say deparment table)Release 2. In the mapping editor, i created mapping flat file operator and added two attributes to this. I mapped the corresponding attributes from source to target. I also configured the source and target for the mapping object. I set UTL_FILE_DIR='f:\kandhuri' in init.ora file. Validation is successful with one warning to verify the path for UTL_FILE.
When I ran the deployment manager it results in error with the following message : Could not find location FLOC -- FLOC is the location for Flat File Module defined in Designed time.. Could you please let me know the reason of this error. Even the file is not creating on the server....higly appreciate your help..

Thanks in advance,
Srikanth

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 10 2004

Added on Aug 12 2004

#data-warehousing, #warehouse-builder

2 comments

210 views