foalabs

Query to find DFF Related Information in Oracle Apps Query: ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN' SELECT        fdf.title                             "DFF Title",        fdf.application_table_name            "Application Table",        fdf.context_column_name               "Context Column Name",        --        fdfcu.descriptive_flex_context_code   "DFF Context Code",        fdfcu.column_seq_num                  "Sequence",        fdfcu.end_user_column_name            "Segment Name",        fdfcu.application_column_name         "Column Name",        -- ...

EBS - Step by Step Oracle Apps Cloning 12.2 with 19c Database using RMAN Step by Step SOURCE Instance: ORACLE_SID=FUAT EBS: 12.2.10 AD/TXK: Delta 12 DB Version: 19.10 Container DB Name : funcdb Pluggable Database =FUAT OS Version: OEL 7.9 Datafile: on ASM (NON-RAC) Target Instance: ORACLE_SID=BEE EBS: 12.2.10 AD/TXK: Delta 12 DB Version: 19.10 Container DB Name : beecdb Pluggable Database=BEE OS Version: OEL 7.9 Datafile: on ASM  (NON-RAC) Let's DO it.. Note: I am creating a shared folder between my source and target server so that I can use it for taking all backup and restoring from same. /media/ sf_19c_EBS12210_Backup 1. RUN AD PRE-CLONE UTILITY on DB and APPS Nodes a) Make sure the cdb listener and database (CDB and PDB) is running SQL> select name,open_mode from v$database; NAME      OPEN_MODE --------- -------------------- FUNCDB    READ WRITE SQL> show pdbs     CON_ID CON_NAME                ...