Oracle 23ai — Transport Tablespace over Network
In Oracle version 23ai, the Transport Tablespace feature can now be implemented over the network . To achieve this, you must use the RMAN tool, which transfers the datafiles of the desired tablespace from the source database to the destination database. This process is done by executing the RESTORE FOREIGN TABLESPACE command in the destination database. With this command, even the metadata of the tablespace is transferred to the destination via a generated dump file and is automatically restored in the target database. Executing the RESTORE command requires some preparations, which are explained below. We intend to transfer a tablespace named TBS1 from APDB to BPDB : Source: APDB Destination: BPDB Step 1: Set the tablespace to READ ONLY --source SQL > alter session set container = APDB; Session altered. SQL > ALTER TABLE SPACE tbs1 READ ONLY ; Tablespace altered. Step 2...