How to install PDMLink with Oracle on AWS-RDS?

HI jdiianni,

We installed windchill with following steps, and windchill is working well without problem.
I hope this is helpful for you.

1.Create tablespace on RDS
refer to below article.
https://www.ptc.com/en/support/article?n=CS28194
In case of RDS we cannot use path of datafile, so execute following SQL.

CREATE TABLESPACE "BLOBS"
DATAFILE
SIZE 1G
AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
LOGGING
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENT SPACE MANAGEMENT AUTO;

CREATE TABLESPACE "INDX"
DATAFILE
SIZE 1G AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED
LOGGING
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;

CREATE TABLESPACE "WCAUDIT"
DATAFILE SIZE 1G
AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED
LOGGING
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;

2. Create user for windchill.
create user <USER> identified by <PASSWORD> default tablespace USERS temporary tablespace TEMP quota unlimited on USERS;
grant connect, resource, create sequence, create view, query rewrite, unlimited tablespace, select any dictionary to <USER>;

3. Install windchill by PSI.
Install windchill by PSI without creating database schema option.

4. CREATE_DDL
Execute DDL SQL by user for windchill(created in step 2) with SQLPLLUS.
DDL SQL = $WT_HOME/db/sql3/create_ddl_wt.sql

5. import basedata of windchill
Execute import basedata with following windchill command with windchill shell.
windchill wt.load.WindchillLoader -All -Unattended

When windchill and database is installed separetely, need to check amount of attribute columns.
https://www.ptc.com/en/support/article?n=CS55464