As we know in an Oracle database through User Profiles we can set restrictions on user groups regarding when and if a password expires (PASSWORD_LIFE_TIME), how many days it can be changed before it stops... read more
How do we change the name of the user / schema in an Oracle database
Using an Oracle Database we may at some point need to change the name of a user and a schema. Until version 11g this was not possible and we would have to create a new user and export/import with remap_schema. We can… read more
How do we apply a patch in an Oracle Data Guard environment (even online)
In a previous article we saw how to patch an Oracle database. In this article we will see the same process in an Oracle Data Guard environment on a UNIX operating system. The steps we will follow allow us to… read more
How to manually set up SSH communication between Unix Servers for Oracle Grid Infrastructure and RAC
In this article we will see what to do if during the installation of Oracle Grid Infrastructure on Unix we get an error when we try to Setup SSH connectivity. When we select in the tab below SSH connectivity and Setup for… read more
How to save space from old table partitions in an Oracle database
When we have very large tables, using Table Partitions helps a lot. Table Partition divides the table into smaller pieces depending on the field we have defined as a criterion, e.g. “date of entry”, these tracks can be located either… read more
How to transfer bulk datafiles online to Oracle database
In this article we will see a script with which we can transfer mass datafiles online that we may have created in the wrong location or we want to change their storage in an Oracle database. THE… read more
How to replicate tables from SQL Server to Oracle Database using GoldenGate
In a previous article we saw how we can replicate tables from Oracle Database to SQL Server using GoldenGate. In this article we will see how we can do the reverse from SQL Server to… read more
How to restore datafiles while Oracle Database is running
In this article we will see how in Oracle Database we can restore a datafile that has been deleted or has become corrupt while the database remains "open" and continues its operation. The data to carry out the… read more
How can we get emails whenever syncing to SQL Server via Oracle GoldenGate is having problem
When we synchronize tables through Oracle GoldenGate, it can either stop the extract of the source from writing trail files to the target in the tables, or stop the replicat of the target from applying the trail files. So for any… read more
