![]() Migrating third-party applications that use the Oracle database can also be supported, but do keep in mind, it’s important to ensure that the vendor supports the Autonomous Database. And keep in mind that GoldenGate does have certain restrictions for row ID for nested tables, things such as that. GoldenGate replication can be used to keep the on-premise or the non-autonomous database up and running and online during the process, meaning that you can have a zero down time migration process. It’s a very portable way to load data into a pre-existing or pre-created, new Autonomous Database.Īnother thing to keep in mind is that GoldenGate can be used. And the nice thing about following this approach is it will eliminate legacy formats. So when we look at approaches to move data into the Autonomous Database, data can be obviously moved with Data Pump. Also, use of Data Pump export-import for exporting Oracle databases version 10.1 and higher are required. This is not a supported option as of now.Īlso, keep in mind all legacy features that are not supported must also be removed. It is not possible to migrate to the Autonomous Database by simply unplugging a PDB from an on-premise container database and plugging it into an Autonomous Database. When you look at migrating an existing database into the Autonomous Database, it’s important to realize that a physical database cannot simply be migrated to an autonomous database. ADB also supports shifting data from an OCI application layer, as well as from virtual machines that may be hosted in your cloud tenancy. When it comes to supporting object storage, ADB supports a few third-party cloud object storage platforms, such AWS S3 and Azure Blob, and, obviously, of course, Oracle’s own object storage. When it comes to moving data into the Autonomous Database, Oracle supports many different types of data types, from SQL Loader text files, to export-import dump files, to CSV, to JSON files. When it comes to loading your data, the traditional tools that you are accustomed to using, such as Oracle Data Pump and SQL Loader, can be used to load data into the Oracle database. The first thing to consider when migrating to the Oracle Autonomous Database is how to load and move your data into the Autonomous Database. Crippling by restricting the number of tables and views hides possible bugs that are only visible in the software during the attempt to migrate hundreds of tables and views.This post is part of a series of blog posts on the Oracle Autonomous Database. The only acceptable crippling of the evaluation version is by time. Does not recognize its own baseUrl parameter.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |