![]() ![]() It's one of those things that make you think "why wasn't that there before?", as Greg says though it's now in 11.1.0.7 albeit sketchily documented, so if you're planning to move large files around as part of your ETL proces and you're on the latest version of the database, it'll be worth taking a look at Greg's article. Install Kms Host Office 2016 Reviews here. Move to Oracle Database 11g The whole Story. If you are using Oracle Database 11g Release 1 (11.1.0.7). ![]() 11.1.0.7 is the first database patchset available for the. Im pleased to announce that its now certified with Oracle E-Business Suite Release 12, too. Now in 11g, you can add a PREPROCESSOR clause to your external table DDL to point to an executable that will preprocess and pipe your data, allowing the external table to read from the file via the uncompression utility without having to uncompress it all first. Oracle Database 11gR1 Patchset Version 11.1.0.7 Oracle Database 11gR1. 0 Comments By: Senior Director The Oracle 11gR1 Database version 11.1.0.7 was certified with Oracle E-Business Suite Release 11i last December. cross Endianness, cross version Oracle 9.2.0.7 on HP-UX to Oracle 11.1.0.7 on OEL Constraints 4 months. Prior to 11.1.0.7, if a file that you were going to use via an external table needed uncompressing, you had to do the task prior to reading it using the external table, potentially ending up with an uncompressed file several times larger than the compressed one, or use SQL*Loader and feed data into it via an uncompression utility and named pipes. Upgrade and Migrate to Oracle Database 11g. Just a quick note to point to Greg Rahn's posting on External Table Preprocessors in Oracle 11g 11.1.07. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
May 2023
Categories |