Skip to main content
Waters

Empower 3 : Can't create a new project with copies of methods from another project, error ORA-01536 - WKB6416

Article number: 6416

SYMPTOMS

  • Cannot create a new project with copy of method from another project.

  • In message center of Empower: Oracle Error ORA-01536: space quota exceeded for tablespace 'USER_DATA'

  • clipboard_eeb95ad1528505eb74a4dee82d301f5aa

ENVIRONMENT

  • Empower

CAUSE

Quota of the new project was too low to store methods of the source project.

FIX or WORKAROUND

  1. Specify a bigger quota for the new project. (Confirm quota of the project from which you want to copy methods.)

  2. Another resolution: Use Shallow Copy of Methods if the project is a Full Audit Trail (FAT) project.

    This option only copies the last version of each method, so methods will take less space.
    To activate this option, go to Configuration Manager, menu View/System Policies...
    In "New Project" tab, select "Allow shallow copies between FAT projects".

    clipboard_e7e419323c72bedfeb98c7f3c367750a8

    When you create new project or clone a project, select "Perform Shallow Copy of Methods" to copy only the last version of each method (you need to have a user type with "Allow Shallow Copies of FAT Projects" privileges.

    clipboard_e9553e5518b2102349c9dd9881ea67487

ADDITIONAL INFORMATION


id6416, EMP2LIC, EMP2OPT, EMP2SW, EMP3GC, EMP3LIC, EMP3OPT, EMP3SW, EMPGC, EMPGPC, EMPLIC, EMPOWER2, EMPOWER3, EMPSW, SUP

Not able to find a solution? Click here to request help.