DBohner-(db)
Legendary Poster
Hi All,
Chores of fun here - and trying to figure a manual means to explode/convert the 'single' .stg file(s) in XE to the multiple files of 9.x.
Correct me where I am wrong:
- R8900165 does the conversion of the F00165 from XE format to 9.x format
* It is a Single Function Call that Converts the Whole Table
* It Explodes the number of records per, to the number of attachments
* It Explodes the one XE .stg to the numerous 9.x attachments
Our issue:
- We have zillions of Media Object Attachments in XE (Yeah, I couldn't count all the commas and numbers)
- Our conversion of the attachments starts ... then just dies, several days later
- There is no 'standard' or 'Oracle approved' method to do a partial conversion (% zillion objects today, %zillion objects tomorrow ... %zillion objects ...)
- Oracle responds, convert all objects in one swoop... EWE!
Our desire:
- We'd like to be able to run 'partial' Media Object Conversion (some last week, some this week and the rest after Go-Live)...
- Be able to Data Select on the F00165 and pick the Media Objects to bring across (like who wants to bring work center messages that are five years old???)
That said, I'm reaching out to the community to see Who has done Partial Media Object Conversion (Some Early, Some Now & Some Later). How did you do it, and what were the hitches?
Also - any dreamers that are intimately in-bed with Media Objects and have a desire to chime-in, imaginatively - Please Do! We'd like a solution (and I'm sure a few other installations will, too).
Now - if Oracle is Listening...:
- Wouldn't it be nice if we only converted the F00165 and let the Media Object API convert the XE Media Objects to the latest format upon first use? Imagine how time saving it would be to have a 9.x user open a single, unconverted, XE .stg file and have the API Explode the .stg into 9.x formats - removing the XE .stg upon successful completion? Wow, what a concept that would be???
(db)
Chores of fun here - and trying to figure a manual means to explode/convert the 'single' .stg file(s) in XE to the multiple files of 9.x.
Correct me where I am wrong:
- R8900165 does the conversion of the F00165 from XE format to 9.x format
* It is a Single Function Call that Converts the Whole Table
* It Explodes the number of records per, to the number of attachments
* It Explodes the one XE .stg to the numerous 9.x attachments
Our issue:
- We have zillions of Media Object Attachments in XE (Yeah, I couldn't count all the commas and numbers)
- Our conversion of the attachments starts ... then just dies, several days later
- There is no 'standard' or 'Oracle approved' method to do a partial conversion (% zillion objects today, %zillion objects tomorrow ... %zillion objects ...)
- Oracle responds, convert all objects in one swoop... EWE!
Our desire:
- We'd like to be able to run 'partial' Media Object Conversion (some last week, some this week and the rest after Go-Live)...
- Be able to Data Select on the F00165 and pick the Media Objects to bring across (like who wants to bring work center messages that are five years old???)
That said, I'm reaching out to the community to see Who has done Partial Media Object Conversion (Some Early, Some Now & Some Later). How did you do it, and what were the hitches?
Also - any dreamers that are intimately in-bed with Media Objects and have a desire to chime-in, imaginatively - Please Do! We'd like a solution (and I'm sure a few other installations will, too).
Now - if Oracle is Listening...:
- Wouldn't it be nice if we only converted the F00165 and let the Media Object API convert the XE Media Objects to the latest format upon first use? Imagine how time saving it would be to have a 9.x user open a single, unconverted, XE .stg file and have the API Explode the .stg into 9.x formats - removing the XE .stg upon successful completion? Wow, what a concept that would be???
(db)
Last edited: