Discussions
Categories
- 382.3K All Categories
- 2.1K Data
- 209 Big Data Appliance
- 1.9K Data Science
- 448K Databases
- 221K General Database Discussions
- 3.7K Java and JavaScript in the Database
- 25 Multilingual Engine
- 520 MySQL Community Space
- 467 NoSQL Database
- 7.8K Oracle Database Express Edition (XE)
- 2.9K ORDS, SODA & JSON in the Database
- 492 SQLcl
- 3.9K SQL Developer Data Modeler
- 186.2K SQL & PL/SQL
- 21K SQL Developer
- 293.3K Development
- 7 Developer Projects
- 128 Programming Languages
- 290K Development Tools
- 95 DevOps
- 3K QA/Testing
- 645.5K Java
- 24 Java Learning Subscription
- 36.9K Database Connectivity
- 149 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.9K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 16 Java Essentials
- 144 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 198 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 266 LiveLabs
- 36 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.8K Other Languages
- 2.3K Chinese
- 166 Deutsche Oracle Community
- 1.2K Español
- 1.9K Japanese
- 230 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