Hello together,
lately we upgraded from APEX 5.0 to APEX 5.1. We still had the old users APEX_040200 and APEX_050000. I dropped them and I wanted to drop the correspondent tablespaces.
But in the tablespace for APEX_040200 (named APEX_040200_DAT_OBJ), there are objects from the user FLOWS_FILES.
Until April 2017 we had as middleware Apache and mod-plsql, now we have ORDS.
I assigned a new tablespace (named APEX_050100_DAT_OBJ) as default tablespace to FLOWS_FILES:
alter user FLOWS_FILES quota unlimited on APEX_050100_DAT_OBJ default tablespace APEX_050100_DAT_OBJ;
Now my questions:
Can I move the objects of the user FLOWS_FILES to the new tablespace without risking malfunctions of the applications? Is there any risk in doing this?
Is the user FLOWS_FILES still necessary with ORDS? Or may I drop the user FLOWS_FILES without loosing uploaded images and other files?
OWNER SEGMENT_NAME SEGMENT_TYPE BYTES/1024/1024 TABLESPACE_NAME
-------------------- ------------------------------ --------------- --------------- --------------------
FLOWS_FILES WWV_FLOW_FILE_OBJ_PK INDEX .0625 APEX_040200_DAT_OBJ
FLOWS_FILES WWV_FLOW_FILES_USER_IDX INDEX .0625 APEX_040200_DAT_OBJ
FLOWS_FILES WWV_FLOW_FILES_SESSION_IDX INDEX .0625 APEX_040200_DAT_OBJ
FLOWS_FILES SYS_C004953 INDEX .125 APEX_040200_DAT_OBJ
FLOWS_FILES WWV_FLOW_FILES_FILE_IDX INDEX .125 APEX_040200_DAT_OBJ
FLOWS_FILES WWV_FLOW_FILE_OBJECTS$ TABLE .5 APEX_040200_DAT_OBJ
FLOWS_FILES SYS_IL0000079620C00017$$ LOBINDEX 7 APEX_040200_DAT_OBJ
FLOWS_FILES SYS_LOB0000079620C00017$$ LOBSEGMENT 4033 APEX_040200_DAT_OBJ
8 rows selected.
regards,
Carola