let me first explain my situation. I am running Oracle database 10.2 on linux and i recently made an database link to mysql database. On that Mysql database i got access to one table which is daily populated with data.
Now i want to know what are my options of creating an identical table on my (Oracle) database and populate it with records from table on MySql? When insert happens on MySql table it should also happen on my Oracle table.
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime? I'm talking things like:
* Dropping columns
* Shrinking allocated space
* Removing chained blocks and restoring the PCTFREE
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface. I made a script to download the Alert Log, look for errors, and email me the trace files. In this article I'll describe what I did and share my script.