Hi there,
When using the functionality "database copy"
the creation of tables fails if the default tablespace for the schemas in the target differs from the source.
That's bad and I would consider it as a bug, since such constellation is a normal thing...
While the error message is correct:
Should the default table space of the target schema be recogniced instead?
Or is there somewhere an option to manage that?
I did not found such option so far...
Please check, confirm whether it's a bug or "expected behavior".
Thanks and Regards
Andre
CREATE TABLE "XP_EPM_MIG_INFOS" ("PK" NUMBER....)
SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "APX_USER" ;
Fehler beim Start in Zeile: 7 in Befehl -
CREATE TABLE "XP_EPM_MIG_INFOS" ("PK" NUMBER,...)
SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "APX_USER"
Fehlerbericht -
ORA-00959: Tablespace 'APX_USER' nicht vorhanden
00959. 00000 - "tablespace '%s' does not exist"
