Oracle Database
--
Questions
--
Followers
Top Experts
What are the Upgradation Steps.....Please provide steps
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
Can i inplace upgrade or Back up and restore DB ??
setup the new oracle 11 database
full import the file
your export file will be small
and this will be the fastest way.
here is a reference to the export and import utilities
export:
http://docs.oracle.com/cd/E11882_01/server.112/e22490/original_export.htm#BABBHCIE
import:
http://docs.oracle.com/cd/E11882_01/server.112/e22490/original_import.htm#i1023560
Or Any GUI tool for this purpose???






EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
For XE, I agree with the above posts: ย Export/Import would probably be the best way.
Got can check the following note on Oracle Support for confirm the direct upgrade path:
Database Server Upgrade/Downgrade Compatibility Matrix (Doc ID 551141.1)
http://debaatobiee.wordpress.com/2009/10/17/step-by-step-upgrading-oracle-10g-to-oracle-11g/
In order to upgrade Oracle Database 10g Express Edition (Oracle Database XE) to Oracle Database 11g, you need to install Oracle Database 11g on the same system as Oracle Database XE and use the Database Upgrade Assistant to perform the upgrade.
http://docs.oracle.com/cd/B28359_01/server.111/b28300/intro.htm

Get a FREE t-shirt when you ask your first question.
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
Oracle Database
--
Questions
--
Followers
Top Experts
Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.