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
17 July, 2010

I read an interesting write up yesterday in UK Eureca magazine – EADS is flying harmonised PLM. The background for this...

16 May, 2017

Yesterday, my attention was caught by Develop3D article  – Data management related tools. Al Dean is sharing his thoughts about...

1 September, 2009

Originally, PLM was born to provide solution for big enterprise customers. Aerospace, Defense, Automotive… these are original roots of today...

2 September, 2011

I’m adding another post to my collection of PLM definitions. Gavlin Quinlan came with the blog post on concurrent-engineering blog...

26 January, 2025

A long time ago, I came across a simple formula for building enterprise software: find a stakeholder in a company,...

28 April, 2024

Digital transformation is changing the world. It comes to our everyday lives and businesses. In my earlier articles I touched...

16 January, 2015

Computers are changing the way we work. It is probably too broad statement. But if I think about the fact...

30 August, 2009

Short note this Sunday. Take a look on a very interesting blind test site comparing different search engines – Bing...

21 March, 2021

Containerization is a term that recently started to pop in the roadmap of PLM vendors. What is that? Why is...

Blogroll

To the top