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
2 May, 2012

The first day of ACE 2012 was quite energetic. This is my 3rd year at Aras Community Event. The first...

3 August, 2018

Cloud PLM strategies is an interesting place these days. When you think about how to move from one shining mobile...

4 July, 2024

As we are at the midpoint of 2024, it is a good time to take a look at PLM vendors...

30 November, 2016

For years, one of the most important element of engineering software was to establish data ownership mechanism and lock data...

4 August, 2014

The speed of data creation is amazing these days. According to the last IBM research, 90% of the data in...

3 July, 2012

Social becomes a norm these days. It is interesting to see how many things surrounding us transformed and wearing “social...

6 December, 2012

Have you heard about OWA (Open World Assumption)? If you completed your Math 101 and Mathematical Logic time ago, refresh...

11 February, 2010

Recent presentation on SolidWorks World 2010 about evolution of PLM drove me to think about what is the future of...

19 June, 2018

I’m attending PTC LiveWorx industry event in Boston. This year it called “Digital Transformation Conference”. Well… I’m not surprised. Digital transformation...

Blogroll

To the top