(Jagruti Jasleniya) In this post we will see how we can insert records in specific partition using sql*loader.
Tag: Oracle
Why can’t I open .pkg files?
(Jeff Smith) Store your PL/SQL packages in files with .pkg extensions?
What version is my RAD stack?
(Scott Wesley) A common follow up clarification on forums is regarding the version of the relevant tool.
Renaming Partitions and Subpartitions
(Jagruti Jasleniya) Rename operations in partitions and subpartitions are as easy as renaming tables we just need to take care of syntax.
OIC: How to Force Dehydration in Processes
(Jan Kettenis) OIC Process uses the database to store its state, which is called dehydration. In contrast, restoring that state from the database is called hydration.
How to set the date and time on Linux
(Gerald) A quick post for how to set the date and time on Oracle Linux via the date command. This post is more for my own documentation but hey, it might help others as well.
orachk can now warn about unwanted cleanup of files in /var/tmp/.oracle
(Martin Bach) Some time ago @martinberx mentioned on twitter that one of his Linux systems suffered from Clusterware issues for which there wasn’t a readily available explanation.
AdminClient and Set Commands
(Bobby Curtis) AdminClient is the “new” command line utility that is used with Oracle GoldenGate Microservices. Initally, AdminClient was released with Oracle GoldenGate 12c (12.3.0.0.1) and enhanced in each release there after. With this new command line tool, there are a few things you can do with
Exchange Partition in Oracle
(Jagruti Jasleniya) Exchanging Partitions is something new. And it provides a huge benefits. By exchanging partition you can actually get data quickly in or out of partitioned table.
What’s new with Oracle database 19.4 versus 19.3
(Frits Hoogland) The most notable thing here is an “official” (non-underscore) parameter has been introduced with 19.4, “ignore_session_set_param_errors”.