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
29 November, 2017

Earlier today, I attended Solidworks webinar providing details about new PDM package SOLIDWORKS Manage. The system was first time announced...

30 October, 2012

Last week I attended PLM Innovation event in Atlanta. If you haven’t had a chance to follow my blog last...

8 September, 2010

How to make people to work more efficiently? I think this is an important question. This is a challenge for...

22 January, 2015

One of the most complicated parts of any PLM implementation is data modeling. Depends on PLM vendor, product and technology,...

21 April, 2016

Business environment is changing fast these days. For years, enterprise and manufacturing were very slow moving segments. Long production programs,...

13 September, 2011

I have a feeling “cloud” topic got some dominance for the last days and week. However, the following article about...

27 September, 2020

The model is such a beautiful word. It can be anything. The word model can be a noun, verb, or...

25 April, 2016

Process is one of the fundamental elements in existing product lifecycle system. Most of existing PLM systems are build around...

25 November, 2017

I like Friday evenings. It is a time to relax and make some unusual reading of something completely outside of...

Blogroll

To the top