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
3 April, 2015

  Document management is hard if you do it manually. To manage versions of documents requires you to follow some...

20 September, 2013

Our life is getting more and more web-like. Think about applications and tools we use in our everyday life 10...

31 May, 2010

I bumped into Razorleaf’s blog – 12 Steps EPDM Upgrade Checklist. I find it as a very organizing and quality...

3 July, 2012

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

22 June, 2017

The history of PLM is heavily intertwined with aerospace, defense and automotive industries. Back those days, these industries introduced the...

26 October, 2011

We are in the Q4 of 2011. It is a traditional time start thinking about what is going to happen...

8 March, 2015

I’ve been doing lots of reading today. So, I decided to share some of them related to business strategies, sales,...

28 August, 2013

Are you familiar with 1% internet rule? It is also called 90-9-1 principle. According to this rule, only 1% of...

21 May, 2014

Online business models are disrupting industries. E-commerce was probably one of the first disrupted segments. Just think about it… 10-15...

Blogroll

To the top