INTRODUCTION
The below steps showes us how to migrate a 19c database using Transportable Tablespace.
MIGRATION FROM LINUX TO WINDOWS
MIGRATION FROM LINUX TO WINDOWS BY TRANSPORTABLE TABLESPACE
CREATED A TABLESPACE
CREATED A TABLE BY HAVING DEFAULT TABLESPACE AS TBS(CREATED TABLESPACE),
EXECUTED THE DBMS_TTS.TRANSPORT_SET_CHECK FOR TRANSPORTING TABLESPACE TBS THAT IS TRUE, ALSO CHECKED IF THERE IS ANY VIOLATIONS
CHECKED THE ENDIAN FORMAT ON BOTH THE PLATFORMS
PERFORMED EXPORT BY DATAPUMP FOR TRANSPORT TABLESPACE
DATABASE IN THE WINDOWS PLATFORM
PERFORMED AN IMPORT IN THE TARGET PLATFORM
AFTER THE IMPORT HECK WHETHER THE TABLESPACE IS AVAILABLE AND MAKE IT READ WRITE, CHECK FOR THE TABLE CREATED WITH DEFAULT TABLESPACE(TBS)
Recent Posts
