PLM Migration to… Text?

PLM Migration to… Text?

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


Share This Post

  • Hi Oleg,
    sounds like a breakthrough solution to 20 years of misguided work in the fields of long term archiving and product data standards (STEP) 🙂
    I would agree that product data is the main asset of a company. The company should protect this asset by managing the data model, by storing the data in open, standard formats, by monitoring the data quality etc.
    Best regards, Jens

  • beyondplm

    Hi Jens, Thanks for commenting! I agree – data should be ‘open’ and ‘safe’. These are two orthogonal things. In most situations, there are two questions you can face in the exact following sequence: 1/how to make data available?; 2/how to protect data from the “global availability?. Best, Oleg