Manage

Transportable tablespaces for Oracle on Linux upgrade

We want to migrate Oracle 9i on Red Hat Advanced Linux 2.1 to Oracle 10g R2 on Red Hat Enterprise Linux 4. Can I use transportable tablespaces to move my data to the new server that we are building?

Maria Anderson

Published: 23 Apr 2007

The goal is to migrate Oracle 9i (9.2.0.3 EE) on Red Hat Advanced Linux 2.1 to Oracle 10g R2 (EE) on Red Hat Enterprise Linux (RHEL) 4. I have read a number of documents but since we are upgrading our operating system we would like to do a fresh install of Linux and OCFS2, thus my question is, can I use transportable tablespaces to move my data to the new server that we are building?

You should be able to use transportable tablespaces to migrate your database from Oracle 9i to 10gR2. There are, of course, some limitations:

The compatible parameter must be set to at least 8.1 in both the source and target databases.
You must be using Enterprise Edition to generate a transportable tablespace set (which you are).
The source and target databases must have the same character set and national character set.
The tablespaces you wish to transport must be self-contained tablespaces. Use the DBMS_TTS.TRANSPORT_SET_CHECK procedure to check whether this is true.

For additional information on transportable tablespaces, the Oracle Database 10g Release 2 (10.2) Administrator's Guide is a good reference.

Dig Deeper on Oracle database installation, upgrades and patches

All
News
Get Started
Evaluate
Manage
Problem Solve

Related Q&A from Maria Anderson

Using /var/opt/oracle/oratab

Can I use /var/opt/oracle/oratab to specify listener information? Continue Reading

Impact on apps of migration from Oracle 8 to 10g

We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ... Continue Reading

Error in invoking target install of makefile

I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error: "Error in invoking target install of makefile /opt/oracle/...../*.mk." Continue Reading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our Oracle Database / Applications experts

View all Oracle Database / Applications questions and answers

SearchDataManagement

Managing unstructured data is crucial to enterprises' AI goals

Unstructured data makes up a huge portion of most businesses' data volume. But, with data-hungry AI systems coming online, making...

ScyllaDB set to improve NoSQL database performance

ScyllaDB has been helpful for big organizations such as Comcast, which was able to trim from nearly 1,000 database nodes to 78 ...

Translytical data platforms provide options to unify databases

Forrester identifies top vendors in the translytical database category and common elements that help make the unified database ...

SearchBusinessAnalytics

Yellowfin 9 marked by developer tools, revamped mobile app

The latest product update from BI vendor Yellowfin features new dashboard design tools, a revamped mobile app and a repackaged ...

Evolution of analytics marked by wider dissemination of data

With BI platforms getting easier to use by the year and enabling more self-service users in process, the value of analytics is ...

Analytics revolution has spread the wealth of information

Business intelligence over the last 20 years has been marked by the opening up of data to everyday business users after it was ...

SearchSAP

SMBs focus on future with S/4HANA and SAP intelligent enterprise

Medical device startup Enable Injections is small now but intends to be big soon, so it's implementing SAP S/4HANA in phases to ...

A primer on Employee Central Service Center

SAP has created Employee Central Service Center to simplify how HR issues get resolved. Here's a look at who it's for, how it ...

SAP sees S/4HANA migration as its future, but do customers?

SAP S/4HANA is seen as an ideal platform for companies to build the intelligent enterprise, but SAP still faces problems getting ...

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 AI application development isn't as far away as you think

The distance between application development and AI development continues to narrow. Here's how to integrate AI into your app dev...

AWS ups Java support, joins Java Community Process

By joining the Java Community Process, AWS will have its say over how the Java language and platform will evolve to meet the ...

AWS gets behind Rust programming language

AWS has joined Microsoft, Google, Mozilla and other major vendors in using and supporting the Rust programming language as a ...

SearchDataCenter

Top 5 options for Linux certifications

Are you ready to expand your Linux knowledge? Here's a look at the latest courses, training content and exams available from ...

New hardware, use cases shape server benchmarking needs

Advancements in server hardware help admins address the latest data-intensive use cases. But this brings questions about the ...

Top guidelines for edge computing software selection

Finding edge software that meets all your organization's needs requires help from both the business and IT sides. Get the right ...

SearchContentManagement

OpenText's Carbonite acquisition expands its cloud portfolio

OpenText acquires Carbonite, a vendor in cloud-based data protection and backup, disaster recovery and end-point security.

Employee engagement necessary for digital transformation projects

With four generations of employees in the workplace and confusion about projects, technology adoption efforts can fall flat. ...

Salesforce CMS: Users can publish without leaving platform

Catering to small and midsize customers, Salesforce remixes and upgrades existing features to form a content management system ...

SearchHRSoftware

ADP DataCloud makes its data easier to use

ADP DataCloud has an upgrade that includes what it calls 'mashup' capabilities. This will make it easier for customers to overlay...

HR mobile apps for employees strengthen HCM strategies

HR mobility management applications play a key role in recruiting, onboarding, talent management, engagements and, ultimately, ...

Impact of HR automation shows up in data and surveys

Recruiters are taking on more strategic roles, thanks in part to automation tools. But HR departments are facing another trend: ...

Dig Deeper on Oracle database installation, upgrades and patches

Related Q&A from Maria Anderson

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.