cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - If community subscription notifications are filling up your inbox you can set up a daily digest and get all your notifications in a single email. X

Translate the entire conversation x

Oracle DB Dump import for WC10

GOKUL1
4-Participant

Oracle DB Dump import for WC10

I am using Windchill PDMLink Release 10.2 and Datecode with CPS M030-CPS27

preparing to upgrade from the WC10 version to the WC13 version, Although there were 1743 errors in the log file during the Oracle DB import, there were no error tables written there.

Could you please clarify whether we can disregard this alert?

Here are the errors that I faced
Last line in the Log file:
Job "SYSTEM"."SYS_IMPORT_FULL_01" completed with 1743 error(s) at Fri May 23 13:07:47 2025 elapsed 0 00:04:44

4 REPLIES 4
GOKUL1
4-Participant
(To:GOKUL1)

 
Jimwang
16-Pearl
(To:GOKUL1)

Based on the error like below, it appears that the Database schema has been on the target database, in fact, it should not be there before the import. Please make sure that the database schema are not been created before importing the dump. You just need to create the database schema user only. 

 

ORA-39151: Table "WTDBUSER"."PARAMETERATTRIBUTEDEFNLINK" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "WTDBUSER"."VARIANTSQUEUEENTRYINFO" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "WTDBUSER"."GENERICVARIANTLINK" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "WTDBUSER"."WPBASELINESEED" exists. All dependent metadata and data will be skipped due to table_exists_action of skip

 

 

Hi @GOKUL1,

 

I wanted to see if you got the help you needed.

If so, please mark the appropriate reply as the Accepted Solution. It will help other members who may have the same question.
Of course, if you have more to share on your issue, please pursue the conversation. 

 

Thanks,
Anurag 

BenLoosli
23-Emerald III
(To:GOKUL1)

What versions of Oracle are you using with Windchill 10 and Windchill 13?

I do not think you can do an upgrade from WC 10 to WC 13 directly. You may need to do an intermediate WC version or two.

Announcements

Top Tags