Recreate the ADF Generated PS_TXN Table

(Doc ID 2360656.1)

Last updated on FEBRUARY 13, 2018

Applies to:

Oracle JDeveloper - Version 12.2.1.2.0 and later
Information in this document applies to any platform.

Goal

After reading the documentation about tuning of the PS_TXN table, it has become necessary to completely drop the table and re-create it in another db schema or, at least, in another tablespace of the same schema.
What's the best practice and what is the COMPLETE procedure to achieve one of these results?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms