Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 238 Big Data Appliance
- 1.9K Data Science
- 450.2K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 544 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.8K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.5K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 154 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 436 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
Moving 1TB Oracle 9i Database on Solaris to Oracle 12c on Linux

We will be modernizing an Oracle 9i Database on Solaris to a supported version of Oracle on Linux. We already have successfully done Dev modernization using exp/imp, but now with Production being over 1TB in size, we are looking for advice on the best method to complete this migration with the least amount of downtime and room for error. We know we cant use RMAN because we are going from Solaris to Linux, and we cant use Data Pump because we are currently on Oracle 9. We could use EXP/IMP, but I am worried about time and risk of error when using exp/imp on a 1TB + Database in size. Do you have any recommendations on how we can proceed with our modernization?
Answers
-
Use Database Link to move tables data or COPY command then indexes, views etc.. can be created on the target using the sql file(INDEXFILE) created by imp command