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
31 October, 2010

I postponed my monthly writing this month to give few words PTC Creo launch this week. CAD community already started...

1 April, 2015

CIMdata PLM forum yesterday was a good place to discuss ideas that from a first look can sound a bit...

7 January, 2010

For the long period of time CAD/CAE/PDM/PLM were recognized as tools for product development and manufacturing. However, modern trends, moving...

23 September, 2015

I started a series of blog posts about PLM dedicated to hardware startups. In my previous article, I explained why...

17 October, 2018

My attention was caught by Facebook video where Stan Przybylinski, VP at CIMdata, was interviewed by Graeme Noseworthy at #AgileEngineering...

7 September, 2024

What is the next big topic in PLM technology, PLM systems, product data management and product development process modeling? Speaking...

21 January, 2010

I was reading Tech Clarity insight “Evolving Role of ERP and PLM“. The topic of PLM and ERP is not...

10 March, 2025

The number of applications and tools created using AI technologies is skyrocketing. It is amazing to see how AI tools...

10 November, 2014

Engineering.com article by Verdi Ogewell earlier today is introducing a next step of PLM vs. ERP battle for ownership of...

Blogroll

To the top