Procedure — Creating a Non-modeled Datastore Sequence in Oracle
When a non-modeled sequence is created, the database schema objects are not included in the Windchill introspection information. Therefore, some tools that rely on this information (e.g.Windu, upgrade tools) will treat these objects as unrelated to Windchill.
1. Create the sequence DDL script "create_<MySequence>_sequence.sql" in "<WindchillHome>/db/sql" directory. For multi-byte systems, use directory, "<WindchillHome>/db/sql3".
2. Add the following lines to this script, substituting <MySequence>, <MySequenceSeed>, and <MySequenceIncrement>.
exec WTPK.createSequence('<MySequence>', <MySequenceSeed>,
<MySequenceIncrement>)
3. Execute the sequence DDL. From a Windchill shell, execute : <WindchillHome>/db/execute_sql_script.bat create_<MySequence>_sequence.sql