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
28 May, 2022

Data is a very fascinating word. A few weeks ago, I was invited by Nina Dar to her Change Troubleshooter...

1 November, 2010

One of the very interesting trends in the modern IT, I’m observing these days is adopting consumer technologies in the...

22 February, 2017

Digitalization is the integration of digital technologies into engineering and manufacturing process by switching from traditional process into a new...

15 August, 2022

It is no secret that PLM (product lifecycle management) and ERP systems are two of the most important systems within...

3 April, 2019

I like data and databases. It is one of my favorite topics. Especially when it comes intertwined with PDM, PLM,...

18 May, 2013

PLM and ERP integration is not a new topic. Step in the discussion about any PLM implementation and you will...

14 May, 2012

Normally, I’m trying to avoid the topic of PLM competition. Not very often, readers or attendees at conference are approaching...

12 April, 2016

One of the topics, I’m following on my blog for long time is open source. Open source software (OSS) or free...

29 October, 2023

Every business is looking for three things: how to make more money, save costs, and reduce risk. Manufacturing companies are...

Blogroll

To the top