2019-01-16

Oracle Data Pump Errors: ORA-31626 and ORA-06512 and ORA-31637 and ORA-31632 and ORA-01422


Problem
While implementing a Data Pump Export script, I started getting the following error stack:
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
ORA-31626: job does not exist
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.KUPV$FT", line 1183
ORA-31637: cannot create job CSEXPDP_01 for user SYS
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1176
ORA-31632: master table "SYS.CSEXPDP_01" not found, invalid, or inaccessible
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1167
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "SYS.KUPV$FT_INT", line 2566
ORA-06512: at "SYS.KUPV$FT_INT", line 2556
ORA-06512: at "SYS.KUPV$FT", line 1092

Cause & Solution
In my case the error was caused, because my script used the same name for the Database Directory and the Data Pump Job.
For example:
It created a DB-Directory like this . . .
CREATE OR REPLACE DIRECTORY tmp_auto_dp_01 AS '...';

. . . and specified a DataPump job name like this:
JOB_NAME=tmp_auto_dp_01
DIRECTORY=tmp_auto_dp_01
SCHEMAS=...
DUMPFILE=...
LOGFILE=...

I hope it helps someone

2019-01-07

USB-C Magnetic Adapter

Since 2016, when I have bought an Asus ZenBook with only one USB connector (USB Type-C / USB 3.1) I have been looking for a possibility to spare this adapter.

Since then I have been looking for a magnetic adapter but I could not find a fully USB 3.1 compatible adapter also capable to transfer data. Most of the magnetic adapters where only capable to deliver power or to be used to transfer small amount of data with mobile phones.

The only adapters promising to be fully USB 3.1 compatible where published on crowdfunding platforms like Kickstarter or Indiegogo, but they all seemed to be scams.

So I was very happy when I found such an adapter in AliExpress. I almost could not believe it.
But since it wasn't so expensive I gave it a try and ordered one.
The adapter worked like a charm.
I successfully tested the following functions:

  • power delivery for my notebook
  • network 
  • USB data transfer to mouse, keyboard, USB stick, SD card
  • video 
  • sound

I could also successfully perform the tests from above with my wife's notebook Lenovo Yoga.

I am using the first adapter for around two months without problem.

So I ordered three more adapters they all worked. Only one of them is more "sensitive" to shake.

Here some pictures:




There are several shops offering this product.
I ordered my adapters on the following one:

New 20 PIN Type C Magnetic Adapter For Macbook Pro MateBook Fast Charging TYPE-C Port Laptop Magnet USB-C Data Cable Adapter


It is not my intention to make advertising in my blog and I have no relation with AliExpres the shop on the link above or anyone related to this product.
I am only so happy to have found this product that I want to help others find it.