exporting the users table from DB2 to Oracle

[rajesh]

Hi,

Can anyone help me with exproting the root.arsuser table from DB2 to Oracle.

Kindly suggest possible solutions.

[Alessandro Perucchi]

??? I am not sure to understand what you want to do here...

If you need that we help you with that easy table... and you want to migrate from DB2 to Oracle... then it shows only one thing... you are not doing the correct thing.
And according to your older post, you have DBAs that have done the migration... so what is the problem, have they not do the correct thing?

without explaining what you did, why you need it, what are the problem that you are encountering, etc... etc... NOBODY can help you.

[rajesh]

Alessandro,

thank you for replying to my post.

the user list which are present in the Oracle are from 2012 few users are missing. so i thought to update/reload the user table from DB2 to Oracle now.

Can you please suggest.

[Alessandro Perucchi]

Hello Rajesh,

ok, then the solution is not by messing with the database (in fact this is nearly always the wrong solution), please do an extract with ARSXML from both system, do some kind of diff.
And then load the missing users again with ARSXML.

Here is a simple XML to export all users:

Code Select Expand


<?xml version="1.0" encoding="UTF-8"?>
<onDemand xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="<path_to_>ondemand.xsd">

  <user name="_ALL" />

</onDemand>