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

Pandemic exposes difficulty of data management in education

Limited resources and a shift to remote learning have shown the inequalities across school districts when it comes to data ...

Aerospike Connect improves integrations with NoSQL database

Aerospike updates connectors for popular data query and event streaming tools, including Kafka, Spark, Pulsar and soon Presto, ...

Explosive Snowflake IPO advances cloud data warehouse fortunes

Snowflake goes public in a big way on the New York Stock Exchange, raising more than $3 billion as enterprises increasingly move ...

SearchBusinessAnalytics

Analytics in construction has potential to save lives

While minor injuries are on the decline in the construction industry, the rate of fatalities has remained flat, and BI could be a...

Miscues in 2016 inform presidential polling data in 2020

Polls and predictive analytics models are improved in 2020 after the failure to accurately predict the outcome of the 2016 ...

New NLP capabilities highlight Qlik Sense update

Enhancements to Insight Advisor, an AI-powered chatbot that helps users make decisions based on their data, are at the core of ...

SearchSAP

Real-life look at SAP intelligent RPA uses, benefits, limitations

SAP intelligent RPA works with the SAP ecosystem to help automate time-consuming processes. Learn what intelligent RPA is, how ...

AWS: Cloud migration doesn't require a move to S/4HANA

The AWS approach for migrating SAP systems to the public cloud doesn't emphasize a move to S/4HANA but enables customers to go at...

SAP sets alternatives to master/slave, blacklist/whitelist

SAP is making language for documentation, training materials and user interfaces and on websites more inclusive.

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

WebAssembly Hub boosts Envoy filter development

Examine WebAssembly Hub's features, why developers have turned to the portal to share Envoy filters and how it seems to be built ...

How to scale automation in DevOps environments

With the right tools and processes, programmers can automate at scale many of today's manual tasks. Here's how one company ...

Microsoft makes TypeScript 4 generally available

Microsoft has made TypeScript 4 generally available for developers building large systems in JavaScript. TypeScript, a superset ...

SearchDataCenter

6 steps for effective real-time monitoring across hybrid IT

Infrastructure monitoring can span multiple stakeholders, data center sites and metrics. Use the five W's to establish a ...

IBM roadmap promises a 1,121-qubit quantum computer by 2023

IBM outlined plans to deliver a series of quantum computers over the next three years culminating with IBM Quantum Condor, a ...

Mega Hopex update focuses on aligning IT to business goals

Mega's Hopex upgrade adds IT Business Management, Information Architecture and Risk Management features designed to help users ...

SearchContentManagement

Knowledge bases benefit customer service, call center training

Knowledge bases provide call center agents with training documents and answers to frequently asked questions as they continue to ...

Box Shield, mobile app upgrades on the way

Among a slew of coming upgrades, Box Inc. goes after Microsoft's government business with FedRAMP High certification.

Episerver to buy Optimizely, adds to CMS, e-commerce suite

As Episerver evolves into a digital experience platform under new leadership, the company adds native A/B testing functionality ...

SearchHRSoftware

Amazon Career Day makes strong pitch with a soft touch

Amazon's virtual career day put the best possible face on the firm in its push to fill 33,000 corporate and tech jobs as well as ...

Don't risk your business internationally with noncompliance

Companies need to ensure they take compliance seriously when expanding internationally. They need to make sure they are compliant...

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.