NAME | INSTANCE_NAME | STARTUP_T |
---|---|---|
T24MU | t24mu2 | 15-NOV-24 |
SQL> show pdbs -- if cdb
SP2-0158: unknown SHOW option "--"
SP2-0158: unknown SHOW option "if"
SP2-0158: unknown SHOW option "cdb"
SQL> show pdbs
SQL> select * from V$ONLINE_REDEF;
SID | SERIAL# | REDEFINITION_ID | TABLE_OWNER | ORIGINAL_TABLE_NAME | INTERIM_TABLE_NAME | PARTITION_NAME | OPERATION | SUBOPERATION | DETAILED_MESSAGE | PROGRESS | REFRESH_STATEMENT_SQL_ID | REFRESH_STATEMENT | CON_ID |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11891 | 36867 | 22 | T24PROD | FBNK_AC_C002 | FBNK_AC_C002B | START_REDEF_TABLE | complete refresh MVs | step 6 out of 7 | ghusbaq62jb0u | /* MV_REFRESH (INS) */INSERT /*+ APPEND SKIP_UNQ_UNUSABLE_IDX */ INTO "T24PROD". "FBNK_AC_C002B"("RECID","XMLRECORD") SELECT "FBNK_AC_C002"."RECID" "RECID",SYS_M AKEXML("FBNK_AC_C002"."SYS_NC00003$") "XMLRECORD" FROM "T24PROD"."FBNK_AC_C002" "FBNK_AC_C002" | 0 |
SQL> spool off