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
22 April, 2018

I enjoyed the discussion around the article I published earlier this week – Model-based confusion in 3D CAD and PLM....

15 January, 2025

I’m sure you’ve been thinking about hiring product lifecycle management consulting during the journey of PLM strategic planning and implementation....

19 November, 2015

IoT is a huge technological and marketing buzzword these days. IT is enabled by internet communication, broad adoption of sensors...

23 March, 2019

TGIF. It is a time to think about an everlasting topic – debates about PLM complexity. I was happy to...

1 October, 2023

Digital transformation is a strong trend in the development and evolution of CAD, PDM and PLM tools. I’ve been following...

5 September, 2011

Product Data Management is not a new term. The first appearance of PDM software goes back in early 1990s (I...

26 June, 2021

Efficiency and productivity are at the core of many decisions made by manufacturing companies. How to reduce the cost and...

4 February, 2014

Collaboration was always in the focus of engineering software. Started earlier with CAD and product data management, software vendors tried...

7 May, 2015

Product cost is the top priority for every manufacturing organization in the world. It can be large OEM or small...

Blogroll

To the top