Use the GET_FILE or PUT_FILE procedure in the DBMS_FILE_TRANSFER package to transfer the data files. If the source platform's endian format is different from the target platform's endian format, then use one of the following methods to convert the data files: If the source platform and target platform are different, then check the endian format of each platform by running the query on the V$TRANSPORTABLE_PLATFORM view in " Transporting Data Across Platforms". Transport the data files for all of the user-defined tablespaces in the database.Ĭopy the data files to a place that is accessible to the target database. The export dump file includes the metadata for objects contained within the user-defined tablespaces and both the metadata and data for user-defined objects contained within the administrative tablespaces, such as SYSTEM and SYSAUX.Ĭopy the export dump file to a place that is accessible to the target database. If the source database contains any encrypted tablespaces or tablespaces containing tables with encrypted columns, then you must either specify ENCRYPTION_PWD_PROMPT=YES, or specify the ENCRYPTION_PASSWORD parameter.
If the source database is an Oracle Database 11 g Release 2 (11.2.0.3) or later Oracle Database 11 g database, then you must set the VERSION parameter to 12 or higher.
Details for each task are provided in the subsequent example.Īt the source database, place each of the user-defined tablespaces in read-only mode and export the database.Įnsure that the following parameters are set to the specified values: The following list of tasks summarizes the process of transporting a database using an export dump file.
0 kommentar(er)
