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

GPU databases bring greater parallelism to big data processing

GPU databases offer a new way to process data. 451 Research analyst James Curtis discusses where they fit in big data ...

Distributed SQL database wagered on for scalability boost, GDPR

CockroachDB is a distributed database system that seeks to support processing on a global scale, a need that online gambling ...

GDPR data protection edicts make good data governance a must

The European Union's new GDPR law puts the onus on companies to ensure that their data governance and management practices enable...

SearchBusinessAnalytics

Ten KPI templates for your dashboards

KPIs help companies gauge success, but how do you choose the right metrics to create useful reports? Here you'll find 10 KPI ...

Data visualization process demands smart design, accurate data

Well-designed data visualizations can enable executives to make more-informed business decisions, increasing the potential ROI of...

Seven good data visualization practices for visual integrity

Data visualizations need visual integrity to ensure that the data they present can be interpreted correctly. Follow these design ...

SearchSAP

Inside SAP's digital transformation strategy

In this Q&A, Bertram Schulte, SAP's chief digital officer, discusses the how and why as the company goes through its own internal...

SAP Cloud Platform pushes to break new ground, extend ERP

SAP wants its Cloud Platform to connect ERP systems with new technology like machine learning and IoT, resulting in new processes...

SAP Cloud Platform architecture is glue for new technologies

SAP Cloud Platform has numerous integration tools for linking next-gen technologies like blockchain, machine learning and IoT to ...

SearchSQLServer

Azure Cosmos DB features, pricing morph with new provisioning model

The ability to provision Azure Cosmos DB throughput at the database level could come with pricing sticker shock for some users of...

Why running SQL Server on Docker is no longer frowned upon

Microsoft now lets SQL Server databases run in Docker containers, a capability that depends on using volumes to store data in a ...

What the Microsoft GDPR compliance toolkit offers for SQL Server

The set of GDPR compliance tools that Microsoft offers for SQL Server is designed to make it easier for users of the database ...

TheServerSide.com

How to calculate McCabe cyclomatic complexity in Java

An understanding of how to calculate McCabe cyclomatic complexity in Java is the first step in better testing and improved ...

Why you need to learn these automated testing tools for Java

How do Selenium, Junit, Grinder and other automated testing tools work? Here's a tool-centric guide to unit testing, integration ...

Fix broken builds with this log4j Maven dependency example

DevOps professionals need to know how Maven dependency management works. This log4j Maven dependency example demonstrates how to ...

SearchDataCenter

Assess network device monitoring capabilities with these tips

Organizations considering new network device monitoring software should evaluate the alerting capabilities and extensibility of ...

Hadoop cluster capacity planning best practices

Trying to calculate Hadoop cluster capacities isn't always straightforward. It's important for organizations to include IOPS and ...

Decide which application monitoring software is right for you

Organizations that want to implement application monitoring tools should consider how the tool gathers and reports information, ...

SearchContentManagement

New age collaboration tools empower the future of ECM

Document management, file-sharing and ECM platforms might represent 'ancient' 1990s technology, but AI and collaboration tools ...

Future of collaboration technology: More Slack and AI, less email

Companies have moved beyond messaging and email to Slack, Teams and even AI-powered scheduling and voice recognition. Are you ...

Adding artificial intelligence bots to Cortana for Office 365

AI bots aren't just for requesting songs and definitions anymore. As enterprises look for ways to bring virtual assistants into ...

SearchHRSoftware

Huge potential of video interview software comes with risks

Tech-savvy millennials' advantage over older workers risks ageism, and AI needs work handling emotions and ethnicity. But few ...

How to solve six of the biggest employee retention challenges

Recruiters are enticing workers with new opportunities on an increasingly frequent basis. Give your employees plenty of reasons ...

Recruiting online giants turn to new technologies

Technology is driving major changes to the recruiting online market. Monster.com and CareerBuilder.com have deployed new job ...

Related Resources

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.