AutoSys Workload Automation

 View Only
Expand all | Collapse all

Can I create User Table HMP_JOBINFO on the same Tablespace used by Workload Automation AE?

  • 1.  Can I create User Table HMP_JOBINFO on the same Tablespace used by Workload Automation AE?

    Posted Aug 24, 2021 11:07 PM
    In an AutoSys R11.3.6 SP5 environment, DBMS:oracle 12c.
    Can I create User Table HMP_JOBINFO on the same Tablespace used by Workload Automation AE?


  • 2.  RE: Can I create User Table HMP_JOBINFO on the same Tablespace used by Workload Automation AE?

    Posted Sep 23, 2021 02:33 AM
    You can, BUT please DO NOT. Any future maintenance (upgrade, incremental, SP, anything) will fail saying you've got some table(s) that don't belong. Even autobcp fails if you are on dual databases.