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
532 views Asked by morfious902002 At
1
There are 1 answers
Related Questions in ORACLE
- sqlplus myusername/mypassword@ORCL not working with Oracle on Docker
- Oracle setting up on k8s cluster using helm charts enterprise edition
- Oracle Managed Data Access Client can't work from IIS but work for local debug environment
- If composite indexing created - indexing is called?
- Oracle Http server ISNT-07551
- why here not creating table?
- Data migration from Oracle Database Clob to GCP Bucket
- SQL Alchemy custom type, forcing blob bind parameter
- How to send message to syslog agent in plsql
- Whatever the data available in previous record it should add to the new record
- I have an Oracle SQL query that is giving me a "ORA-00918: column ambiguously defined" error on a line that is a comment line
- 'ORA-12170: TNS:Connect timeout occurredORA-12170: TNS:Connect timeout occurred' ERROR while working on oracle with laravel
- Is their any way i can open parallel query tabs
- VSCode Libraries not showing for New Java Project
- I can't ssh to my instance, Connection refused
Related Questions in AMAZON-WEB-SERVICES
- S3 integration testing
- How to get content of BLOCK types LAYOUT_TITLE, LAYOUT_SECTION_HEADER and LAYOUT_xx in Textract
- Error **net::ERR_CONNECTION_RESET** error while uploading files to AWS S3 using multipart upload and Pre-Signed URL
- Failed to connect to your instance after deploying mern app on aws ec2 instance when i try to access frontend
- AWS - Tab Schema Conversion don't show up after creating a Migration Project
- Unable to run Bash Script using AWS Custom Lambda Runtime
- Using Amazon managed Prometheus to get EC2 metrics data in Grafana
- AWS Dns record A not navigate to elb
- Connection timed out error with smtp.gmail.com
- AWS Cognito Multi-tenant Integration | Ok to use Client’s Idp?
- Elasticbeanstalk FastAPI application is intermittently not responding to https requests
- Call an External API from AWS Lambda
- Why my mail service api spring isnt working?
- export 'AWSIoTProvider' (imported as 'AWSIoTProvider') was not found in '@aws-amplify/pubsub'
- How to take first x seconds of Audio from a wav file read from AWS S3 as binary stream using Python?
Related Questions in MIGRATION
- How Do Schema migration in mongoose & mongodb?
- WPF Windows Initializing is locking the separated thread in .Net 8
- Migrate data from MySQL to PostgreSQL In Azure
- migrate error : ...No migrations to apply
- After upgrading Alfresco from 5.2 to 7.2 getting failed to initialize keystore error. Our old repository is in Alfresco 5.2
- Convert Neoload script to LoadRunner script
- Migration of UseOAuthAuthorizationServer from .Net Framework to .Net8
- Migrate multiple notebooks from current environment to new environment
- How to Generate a Migration Script in the Azure DevOps
- C# Project Coding
- Blazor hybrid cant add migration
- Migrate from SAML extensions to SAML service provider and spring security
- Ejabberd Migration from 23 to 24
- unable to upload Paginated report
- Android Studio could not build Flutter App APK after migration
Related Questions in RDS
- RDS table opened in RStudio. How do I find field Names?
- show timezone - PostgreSQL 11 - different value depending on client?
- Problem connecting to RDS from EC2 instance: Is the server running on host/accepting TCP/IP connections on port 5432?
- Why master user does not have all privileges on all tables in RDS postgres?
- ERROR 1064 (42000) Delete statement in RDS
- I cant connect to AWS RDS using Postgres
- RDs format weights more than csv one for the same dataframe
- Postgres select query with exclusice lock performance issue
- Postgresql ERROR: could not establish connection
- cannot connect to RDS SQL server through powershell
- Trigger is not working in Amazon Aurora when executing Liquibase changeLog
- RDS Gateway > Update Resource authorization policies with Powershell
- Ad network traffic and Lambda invocation mismatch
- Can no longer connect to RDS MySQL after upgrading to Ubuntu 20.04 (rails)
- How to set up connection to AWS rds via ssh to server from python?
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?
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)
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.