Of course you can and yes there are restrictions, for example you cannot transfer the SYS schema. Upgrading is not the same process as data migration and uses different tools and concepts. Restrictions or features of the Database Upgrade Assistant (DBUA) are not the same as using Datapump export and import. People have written books and other information about it. You can use Oracle database Import and Datapump tools to import data from any previous version, unlike DBUA which is limited by an upgrade path.
Please do some preliminary practice and reading. There is plenty of info out there, including the Oracle documentation library, for example:
If you have questions about the Oracle import, export, or datapump utilities, please post in the appropriate forum space: Export/Import/SQL Loader & External Tables
Sure i will go through all those things.Also i think there is no need to use version parameter in this migration?
So we can migrate 11grelease1 database using expdp and can import it in 12cr2.
Please correct if i am wrong,so that i can mark this thread as correct answer
When going to a newer version, then there is no need to use the "version" parameter. The newer version datapump will fully understand the "old-release" dump file.
Here are some additional things to consider:
1) You are upgrading to database 12.2 which is going out of support in November. I strongly recommend you to consider going to database 19c which will be supported until March 2023, and with paid option to March 2026.
2) Depending on the size of the database and your requirements for downtime, you could also consider using transportable tablespaces and transport the user data tablespaces into the new release. If your database is big this option can be MANY times faster. My fellow Product Manager Mike Dietrich has some slides on this topic:
3) You don't need to make a export to a dump file, transfer dump file and do import. You can do the import directly from the source database using a database link:
Again, yes, you can use Oracle 12c to import data from any previous Oracle version using import/export or the datapump tool. Your initial post does not mention anything about a version parameter. If you have a question about the version parameter, please indicate that in your initial post, using an appropriate subject line. Please do not post a general question and then use the same thread to report all sorts of problems or questions you run into. That's not how it works here.
Thanks for the suggestions.Our database size is 120GB and our source db version is 18.104.22.168.0(initially i wrote as 22.214.171.124,its a typo).
In this case,is it possible to use network_link parameter?
Also,please let us know if we need to shut down the application while performing this actvity,so that changes will not be done to source database?
The network_link parameter has been there for a long time. You should skip the entire export part (expdp) and then just run imdp specifying the NETWORK_LINK parameter to make the import takes the data directly from source database.
Migrating a database this way is an offline approach, so you need to shut down your application before you start the import (or export if not using network_link parameter).