OWB 11g Mapping Execution Fails With ORA-00959: tablespace 'XXXX' does not exist
Last updated on MAY 05, 2017
Applies to:Oracle Warehouse Builder - Version 184.108.40.206 and later
Information in this document applies to any platform.
OWB 11g Mapping execution fails with:
Objects including OWBSYS objects have been moved from one tablespace to another tablespace.
Sample of steps :
- Move all objects from tablespace DEV to tablespace MYREORGTBS
- Drop tablespace DEV
- Move all objects from REORG to new tablespace MYNEWTBS
- Drop the REORG tablespace
- Execute Mapping (pl/sql package) and it is generates the ORA-00959
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