Have a need that only want to import a few columns to a table and leave the other columns in the table untouched. Is it possible with impdp? For example,
Have a table T with 3 columns as follows:
col1 col2 col3
Want to import only columns col1 and col2 and keep col3 untouched.
If impdp can not do that, is there any better way to achieve it?
Cursors in Oracle:
A cursor is used to process individual rows returned by database system for a query.
In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
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.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…