Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is an object-relational database management system produced and marketed by Oracle Corporation. 10 Exporting and Importing Metadata and Data. This chapter describes how to export (unload) from and import (load) into Oracle Database XE. You can export and import. RMAN Cross- Platform Migration with the convert database command. Cross- Platform Database Migration. Starting from 1. 0g. R2, Oracle introduced the next magical feature. RMAN its ability to convert the database from one platform to. Our. application developers created a big project that uses an Oracle. Windows OS. The whole project should be. Linux OS. After receiving this call, Bob decides to use RMAN 's Cross. Platform Migration feature to migrate the whole Oracle database. Windows OS to the Linux OS. SQL> columnplatform. Bring database to the mount mode and open it with the read. SQL> shutdown immediate. SQL> startup mount. SQL> alter database open read only; Database altered. SQL> Use dbms. RMAN> convert database new database. RMAN converted all datafiles to the destination platform type. Perform the following prerequisite actions on the. Create dump directories. Edit parameter file. Windows syntax to the Linux syntax. Now check all changes made above once more, export the. ORACLE. Runs the. PL/SQL objects with. After all the above steps are finished, the database can be.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
August 2017
Categories |