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
1 December, 2016

IoT is coming everywhere these days. The interest in technologies enabling to deliver connectivity between customers, products and product development...

10 April, 2022

Digital transformation is a hot topic in many industries, and manufacturing is no exception. Many manufacturers are looking for ways...

15 August, 2014

Part Numbers is a fascinating topic. I’m coming back to blog about what is the best approach to manage Part...

6 September, 2023

For the first time after COVID, I’m coming to the City By The Bay to attend Autodesk DevCon 2023. For...

26 January, 2011

This week SolidWorks presents the new product SolidWorks n!Fuze. The actual presentation didn’t happen yet. Today is the 3rd day...

17 December, 2022

The PLM industry is finally moving a full speed ahead toward the cloud. Remember the cloud debates 10 years ago?...

2 April, 2012

Few weeks ago, back to my trip to Munich PLM Innovation Congress, I published post – Will Europe Adopt Cloud...

28 January, 2013

I was in the air during this weekend. Literally… Long flights to move from Russia to West Coast of USA....

30 April, 2012

I’m off to Detroit, MI this week for Aras PLM user conference – ACE 2012. Microsoft .NET and MS SQL are...

Blogroll

To the top