Question

2
Replies
201
Views
MichaelF1903 Member since 2012 26 posts
CYBG
Posted: September 15, 2016
Last activity: September 30, 2016
Closed
Solved

Purpose of index tablespaces created during PRPC installation

I recently received an email from our new DBA who assisted with a PRPC installation. He noticed that the PRPC tables and indexes created through the auto-produced oracledate.sql script create tablespaces for both tables and indexes, yet when the indexes are created they are created in the "table" tablespace. The "index" tablespace remains unused.

Is this simply an oversight in the code that produces the oracledate.sql script, or is there some other reason the index tablespaces are created (and not used)?

Many thanks,

Mike.

Data Integration
Moderation Team has archived post
Share this page LinkedIn