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

Ataccama automates data governance with Gen2 platform update

Data management vendor Ataccama adds new automation features to its Gen2 platform to help organizations automatically discover ...

IBM to deliver refurbished Db2 for the AI and cloud era

IBM has a tuned-up version of Db2 planned, featuring a handful of AI and machine learning capabilities to make it easier for ...

Fauna improves data API collaboration and security

A database company founded by former Twitter engineers is pushing forward its vision of a way to consume database as a service ...

SearchBusinessAnalytics

Big data streaming platforms empower real-time analytics

Data streaming processes are becoming more popular across businesses and industries. Read on to see how streaming platform ...

Coronavirus quickly expands role of analytics in enterprises

While NLP and embedded BI were expected to be key analytics trends, the effect of the pandemic on enterprises' takeup of ...

Event streaming technologies a remedy for big data's onslaught

Event streaming is emerging as a viable method to quickly analyze in real time the torrents of information pouring into ...

SearchSAP

Customer input drives S/4HANA Cloud development

In this Q&A, SAP executive Jan Gilg discusses how customer feedback played a role in the development of new features in S/4HANA ...

How to create digital transformation with an S/4HANA implementation

Moving off SAP's ECC software gives organizations the opportunity for true digital transformation. Here are some tips business ...

Syniti platform helps enable better data quality management

FrieslandCampina uses Syniti Knowledge Platform for data governance and data quality to improve its SAP ERP and other enterprise ...

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

Why GitHub renamed its master branch to main

The GitHub master branch is no more. Developers used to think it was untouchable, but that's not the case. Here's why GitHub made...

An Apache Commons FileUpload example and the HttpClient

In this article you will have a look at the capabilities of the HttpClient component and also some hands-on examples.

10 microservices quiz questions to test your knowledge

Don't sweat the details with microservices. Take this 10-question quiz to boost your microservices knowledge and impress ...

SearchDataCenter

Avoid server overheating with ASHRAE data center guidelines

Finding the right server operating temperature can be tricky. ASHRAE standards provide guidance for all server classes and what ...

Hidden colocation cost drivers to look out for in 2021

These unexpected charges and fees can balloon colocation costs for enterprise IT organizations.

5 ways a remote hands data center ensures colocation success

Off-site hardware upkeep can be tricky and time-consuming. With remote hands options, your admins can delegate routine ...

SearchContentManagement

Compare information governance vs. records management

Information governance focuses on the framework a business must follow for managing information, while records management focuses...

5 best practices to complete a SharePoint Online migration

Moving from an on-premises system to SharePoint Online offers businesses new capabilities, such as Power Suite and site analytics...

Top 5 knowledge base products in 2020

One way to increase brand loyalty and customer satisfaction within a company is to have a knowledge base. These products can also...

SearchHRSoftware

Internal talent marketplaces bloom as workforce changes

In this sluggish economy, employers are turning to internal talent marketplaces to connect employees to short-term projects.

HR can't afford to overlook systemic inequity -- here's why

Katherine Giscombe, organizational psychologist and management consultant, argues that firms need to address systemic inequity ...

Understand workplace COVID-19 contact tracing issues, methods

COVID-19 contact tracing for offices, businesses, restaurants and other workplaces is a challenge for employers. Here is a look ...

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.