Manage

How to migrate 1.5 TB Oracle database from Solaris to AIX

We have a huge database (1.5 TB) on Solaris (Oracle 10g) and we want to migrate it to AIX -- is expdp the best solution?

I am a consultant in IT enterprise in Poland. We have a huge database (1.5 TB) on Solaris (Oracle 10g) and we want to migrate it to AIX -- is expdp the best solution? How does it work? What are the possible problems? Thank you.

Changing platforms in Oracle 10g leads me to two paths. One, using Data Pump (expdp) as suggested. Or, using Transportable...

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

Tablespaces (TTS). I like the TTS option for a 1.5 TB database since you can simply FTP your tablespace's datafiles to your new server and plug them in to the new database. The majority of the time is spent FTP'ing the files. With a database this size, Data Pump requires to you export the database's contents, FTP the dump file to the new server, and then import the dump file to the new database. This can be time-consuming.

Refer to the Oracle documentation for information on TTS.

The only downside of TTS is that it only copies tables and indexes. Any stored procedures, views, sequences, etc. need to be re-created in the destination database.

This was last published in August 2007

Dig Deeper on Oracle database backup and recovery

All
News
Get Started
Evaluate
Manage
Problem Solve

Solving common Oracle error codes guide

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

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

Big data management practices gain attention amid risks

Many data professionals have yet to solidify traditional data management practices, but they have a new set of challenges to ...

Aerospike database garners Spark, Kafka connectors

Apache Kafka and Apache Spark connectors ease use of the Aerospike NoSQL data store in high-speed applications such as analytics ...

Data catalog software takes on data lakes, privacy laws

Data catalog systems form a hub for managing a company's data. New products are focusing on machine learning and AI add-ons that ...

SearchBusinessAnalytics

Tableau-VoiceBase deal brings speech analytics data to users

Tableau's partnership with AI speech analytics vendor VoiceBase enables users both inside and outside of the contact center to ...

NYPD's Patternizr crime analysis tool raises AI bias concerns

The NYPD has rolled out Patternizr, a machine learning algorithm that helps analysts identify crime patterns but highlights the ...

Users find data preparation tools vital to BI strategies

Data preparation isn't the sexiest topic, but it's critically important to IT and business users, according to a study by Dresner...

SearchSAP

SAP CEO talks Qualtrics acquisition, says experience data is critical

At the Qualtrics X4 Summit, SAP CEO Bill McDermott argues that experience data is now central to business success. He promised to...

SAP blockchain service helps fight counterfeit drugs

SAP's new blockchain service may help drug wholesalers verify the authenticity of returned drugs, but it faces business process ...

Release of ABAP in SAP Cloud Platform to extend S/4HANA

ABAP's future is bright with the support of SAP technology like S/4HANA, but having ABAP in the cloud will take some adjustment, ...

SearchSQLServer

SQL Server auditing best practices: 3 key questions for DBAs

Acing a SQL Server database audit starts with careful monitoring of how sensitive data is accessed and used so you can answer the...

Talend Stitch tools load data to Azure SQL Data Warehouse

Cloud data warehouses see serious data transformation work moving to the cloud. Talend's first integration with Stitch, which it ...

5 trends for SQL Server environments as SQL Server 2019 looms

SQL Server is undergoing new changes, as Microsoft prepares to release the 2019 version of the database software. Other changes ...

TheServerSide.com

Detect attacker intent with Elasticsearch security plugins

Harden your enterprise with security plugins for Elasticsearch that target hacker behaviors, patterns and goals to limit issues, ...

Fix this runC vulnerability to prevent unwanted root access

Examine a recent vulnerability to the runC container code and what you need to do to prevent unwanted root access and container ...

Get these benefits when you simplify a WebSphere Portal URL

If your Portal URL displays the tired /wps/portal preamble in the browser's location bar, it's time to perform Portal URL ...

SearchDataCenter

Can IT admins benefit from a DevOps environment?

Admins might wonder if they need to pay attention to DevOps, but collaboration with developers helps minimize bad code and ...

4 PowerShell modules every IT pro should know

Find out how to use four of the most popular PowerShell community modules in the PowerShell Gallery to help better manage your ...

IBM quantum computing may arrive sooner than expected

If IBM continues doubling the performance of its quantum computers, as recent benchmarks indicate, it could deliver the first ...

SearchContentManagement

4 Office 365 collaboration tools that mirror SharePoint

In order to convince users to move away from SharePoint, Microsoft has built Office 365 collaboration tools that improve upon the...

9 killer use cases for CMS blockchain

Uses for blockchain technology in content management and social media exist largely in the realm of the theoretical. But there's ...

Content services and archiving records: It's complicated

Content services complicate archiving. Microservices render records dynamically for many devices, while an archive should be a ...

SearchHRSoftware

Users at Qualtrics X4 Summit share a common philosophy on role of HR

Two Qualtrics customers talk about how they've successfully measured employee experience, and how doing so has effectively ...

10 steps for developing a recruiting strategy

To ensure your organization is attracting and hiring the right candidates, evaluate existing policies and strategies and update ...

At Qualtrics X4 Summit, Obama stresses need for facts

Former President Barack Obama discusses his approach to problem analysis and forming a team at the Qualtrics X4 Summit.

Dig Deeper on Oracle database backup and recovery

Related Q&A from Brian Peasland

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.