A blog by Oleg Shilovitsky
Information & Comments about Engineering and Manufacturing Software

PLM Migration to… Text?

PLM Migration to… Text?
Oleg
Oleg
21 February, 2011 | 1 min for reading

Sometime data management Q&A looks funny. World Online Review published the following solution on the request about how to migrate data into the text. Hit this link to read a simple instruction:

1. In sql enter the command SQL>spool
Then enter the required select statment.The entire output is
transfered into the speficied file.The file’s default extension
is LST.Then enter SQL>spool off
2.You can also transfer the contents using utl_file utility.

Migration of PDM/PLM environment is a very complicated task. It is not as funny and simple like SQL recommendation. Think about the option to spool data out of PLM system and get it back in another system. Sounds complicated? However, wait a minute and think one more time… Data is in your PDM Oracle database. You just spool data out of your database. Do you think it is wrong? Not as wrong as you are thinking now. Just my thoughts, of course… YMMV.

Best, Oleg

Recent Posts

Also on BeyondPLM

4 6
16 November, 2016

I attended Autodesk University 2016 opening keynote yesterday. 10’000 people crowd, crazy loud music and future vision of engineering software....

24 July, 2012

I’m not using much Yahoo! products these days. Actually, I do. When I need to find some graphic for my...

3 February, 2010

In my view, we are observing the major disruption of enterprise software business models ever. Since yesterday’s post FREE and...

26 October, 2011

BAM! Aras just announced Enterprise PLM for SolidWorks. Here is the new article – Enterprise PLM for Enterprise PDM. Navigate...

23 May, 2020

Peter Thiel is famous for his recommendations about how to build a monopoly. I recommend his book Zero to One....

10 July, 2014

For the last few years, I’m following cloud strategies of main PLM vendors – Aras, Arena, Autodesk, Dassault, Siemens PLM,...

6 July, 2018

New business model is a big deal in engineering and manufacturing software. For years, customers were buying CAD licenses. For...

7 September, 2020

I had a chance to dig into The State of Product Development 2020 report done by Onshape. You can get...

23 August, 2011

I know, patent stories are hot now. After Google decided to pay Motorola the premium of USD 12.5B to defend...

Blogroll

To the top