Row IDs in Windchill Oracle database.

[avillanueva]

Sorry about the no subject before...



Does PDMLink or Windchill depend upon rowids when doing queries? I am
thinking not. My DBA will be doing a space reclaim (Oracle 10g) and this
will change the rowids. I can't imaging it does since everything in
Windchill relies on IDA2A2 column for identification. We cleaned up our
libraries and the number of objects in the database has significantly
been reduced. 900,000 objects down to 200,000. Anyone know the answer?

[MikeLockwood]

From our Oracle consultant...

When you IMP (import), Oracle will:
1. CREATE THE TABLE
2. INSERT THE ROWS (DATA)
3. RE-CREATE INDEX AUTOMATICALLY
All works again ok.

But, if using:ALTER TABLE (some_table_name) MOVE TABLESPACE (new_created_tablespace); then need to manually rebuild indexes.

[dtkach1]

Nice comment. Thanks Mike.

Dmitry

[avillanueva]

Confirmed with PTC TS. Rebuild indexes and packages and all set.