Manage

How to perform an Oracle 8i to 10g migration

Oracle expert Brian Peasland explains how to perform an Oracle 8i to 10g migration when moving to Oracle 10g R2 with these step by step migration tips.

Brian Peasland

Published: 08 Oct 2009

I have Oracle 8i Release 8.1.6.0.0 enterprise 64 bit. The database size is quite small, say 100GB.

Now we need to migrate to Oracle 10g R2. I have the 8i full dump taken using Oracle 8i. The new Oracle will be installed on Windows 2008 server x64 bit OS and we have Oracle 10gR2 standards 64 bit. I have not yet installed Oracle in the new server. Is there a link on step by step instruction to doing this migration from 8i to 10g you can give me?

Here are the steps for performing an 8i to 10g migration in Oracle:

Install Oracle on your new server
Create the new database using the Database Creation Assistant (DBCA)
Precreate any tablespaces you will need.
Import with FULL=Y. This will create your users and roles and everything else.

Dig Deeper on Oracle database backup and recovery

Related Q&A from Brian Peasland

Managing Oracle connections from third-party apps

Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading

Perfect the Oracle RMAN duplicate 10g command

One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading

Managing SQL parent table-child table relations

Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading

SearchDataManagement

AWS and Oracle battle for hybrid cloud database deployment

Oracle's Autonomous Database and the Amazon Relational Database Service (RDS) are coming down from the cloud and are now ...

SODA Foundation launches to unify open source data management

A new Linux Foundation-sponsored group will support open source data management and promote interoperability between applications...

Informatica expands enterprise data catalog capabilities

Informatica brought new features to its enterprise data catalog, including Data Asset Analytics, a tool to help organizations ...

SearchBusinessAnalytics

Important resources in a data scientist education

There are plenty of resources for data science learning for people entering the field all the way up to managers. Read on for key...

Tellius introduces SaaS version of its analytics platform

Tellius, an analytics startup whose platform is built on AI and machine learning, introduced a SaaS version of its tools to help ...

State of the self-service analytics market

Self-service analytics are important to strong enterprise analytics. Experts talk about how top vendors in the market are keeping...

SearchSAP

Clariba partners with SAP clients for intelligent enterprise

In this Q&A, Marc Haberland, founder of Clariba, explains why SAP needs partners to co-innovate with customers on applications ...

SAP Business One ERP helps SMBs shift with changing markets

Sagamore Spirit and Ellsworth Foods are using SAP Business One ERP to help deal with dramatic changes in demand caused by the ...

SAP Cloud Platform apps deal with pandemic problems

SAP Cloud Platform is proving to be a useful development environment for applications that address issues brought on by the ...

SearchSQLServer

SQL Server database design best practices and tips for DBAs

Good database design is a must to meet processing needs in SQL Server systems. In a webinar, consultant Koen Verbeeck offered ...

SQL Server in Azure database choices and what they offer users

SQL Server databases can be moved to the Azure cloud in several different ways. Here's what you'll get from each of the options ...

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

In this book excerpt, you'll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN techniques and find various examples for creating SQL ...

TheServerSide.com

3 ways a volunteer programmer can help in a pandemic

DevOps pros can help local and state agencies battle COVID-19. Here are three ways they can volunteer their time during a ...

Oracle's release cadence opens door for Java support rivals

Oracle has opened the door for competitors to chip away at its hold on the market for providing Java support to enterprise ...

Dojo Toolkit 7 focuses on JavaScript developer productivity

Dojo Toolkit version 7 is now available. The widely used, mature JavaScript framework favored by enterprise shops gains more ...

SearchDataCenter

IoT data center tech aims to improve operational efficiency

IoT tech can make data center operations data-driven and automated. For a successful implementation, IT managers should evaluate ...

An introduction to DCIM software metrics and terms

Infrastructure management is no easy task. The right software can help admins track how efficient their server racks and ...

6 steps to prep your organization for ISO 9001 certification

ISO 9001 is a quality management standard. Before your team decides to become certified with an official audit, you should have ...

SearchContentManagement

Microsoft products address digital workplace security

Microsoft is enhancing products with additional features to address content security, enabling businesses to minimize risks while...

Why version control is necessary in digital asset management

Version control is essential to DAM systems, as it enables multiple iterations of documents and rich media while retaining the ...

How to use social networking CMS to create social media sites

Whether a company uses its own social CMS or a vendor's platform to create a social media site, it offers more features to users ...

SearchHRSoftware

18 HR cost reduction ideas for the 2020 COVID-19 recession

The COVID-19 recession demands creativity to stay competitive. Here's a look at 18 HR cost reduction ideas -- including freezing ...

HR technology, analytics may help companies through COVID-19

HR technology can play a large role in helping companies navigate through COVID-19, set workforce strategy, and reevaluate HR ...

Investors, lawmakers say HR data should be public

Large investors argue that HR data on diversity and even engagement is critical to understanding the risks that public firms face...

Dig Deeper on Oracle database backup and recovery

How to solve an Oracle import error

Oracle Openworld: Oracle boosts identity management offering

Migrate Oracle 10g database from Linux to AIX

Limit on CLOB datatype in Oracle 10g

Related Q&A from Brian Peasland

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.