I have been assigned to move 10g database to AWS Oracle 12c. Size of data is around 20 GB of actual data but 900 GB has been allocated. So we will need to decrease that. Any suggestions on how to migrate and reduce the size of the database?
Migrating Oracle 10g Enterprise to AWS RDS oracle 12c
528 Views Asked by morfious902002 At
1
There are 1 best solutions below
Related Questions in ORACLE
- Column displays each count
- MAX and GROUP BY - SQL
- Best Practice for adding columns to a Table in Oracle database
- Updating an Oracle row with value from same row
- Retrieving data from Oracle database
- Ibatis execute update sql on oracle, it is not working and no exceptions
- Building an sql execution plan history
- Implementation of Rank and Dense Rank in MySQL
- how to update the date field for this specific condition using oracle query?
- Oracle stored procedure wrapping compile error with inline comments
- Android: How to connect oracle database using Android Java code?
- SQL Conditional Join on Columns
- Multi value wildcard search in ibatis
- Get count of consecutive days meeting a given criteria
- How to update the metadata of a layer in Oracle imported through FME Workbench?
Related Questions in AMAZON-WEB-SERVICES
- "Access Denied" - User's Permissions to S3 Bucket
- Cohort analysis with Amazon Redshift / PostgreSQL
- Using Amazon KMS service on Heroku
- can't ssh in after cloning an EC2 instance on Amazon AWS
- Using HDFS with Apache Spark on Amazon EC2
- How can I access Mule ESB Community edition via browser?
- AWS EC2: Migrating from Windows to Linux Server
- AWS ELB Load Balancer: is it possible to set multiple session cookies?
- AWS Flow Framework: Can we run activity worker and activity task on different EC2 instances
- Unable to access files from public s3 bucket with boto
- Cloudfront stream only part of the video
- s3cmd not working as cron-task when echos/dates are added
- How to deploy django 1.8 on Elastic Beanstalk using Docker
- InstanceProfile is required for creating cluster - create python function to install module
- How to fix WordPress HTTPS issues when behind an Amazon Load Balancer?
Related Questions in MIGRATION
- NoMethodError: undefined method `add_attachment' for #<AddImageCloumnToPost:0x58 ba1b8>
- Not getting Downloaded - "Azure DocumentDB Data Migration Tool"
- migrate one ldap server to another - questions
- Scope attribute migration from Struts1 to Struts2
- Is there any way to rearrange the table's fields in Rails migrations?
- Unable to cast object of type 'System.Web.Hosting.SimpleWorkerRequest' to type 'System.Web.Hosting.IIS7WorkerRequest'
- handling really long migrations in Heroku
- Migrating source code from PVCS to SVN
- I am new to ubuntu.i have installed phpstorm and try to run composer but it's not running
- Magento Fatal error: Call to a member function setData()
- Add comment to SQL table
- Django migration having no effect, on postgres table
- Rollback and Start Over/Pending Migration
- How Django finds all the migrations
- Join table comment in rails 4 migration
Related Questions in RDS
- How do I Start/Stop AWS RDS Instances using Boto?
- ETL Hangs - SQL Server in EC2 Machine + SSIS + AWS RDS SQL Server
- How to set a variable using dynamic inventory using Ansible
- How to connect to Redshift from RDS(sqlserver) via Linkedserver
- java.net.ConnectException: Connection timed out connecting to Postgre on Amazon RDS
- Migrating Oracle 10g Enterprise to AWS RDS oracle 12c
- Using aws php sdk's waitUntilDBInstanceAvailable()
- Tuning Apache & CentOS 7 for Backups
- How to set Amazon RDS SQL_MODE with multiple values
- Amazon RDS master password reset fails
- Search and test connection to AWS RDS using Windows Power Shell
- AWS RDS save snapshot of selected tables
- RDS Security Permissions to Allow Public Read/Write and Private Admin
- TFS server using RDS SQL server connection
- Error by Opsworks : unable to find rds instance with ARN
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
This is a good summary of several options: Importing Data Into Oracle on Amazon RDS
Also here is the Oracle migration Whitepaper.
The solution depends on the size of your data and the accepted downtime.
Personally I used Data Dump in a project, it works well for the size of data you have. I'm not sure about the resizing.