Few users not exported by ora2pg

Open pjayasan opened this issue 4 years ago • 5 comments

Hi Team, I am trying to export all users and grants from oracle using below command. Even though I 'have DBA privilege's to my ID few users has not been exported.I couldn't find any differences between the ID's that has been exported and not exported . Please let me know if anything else need to be added.

ora2pg -t grant -o GTDM_grant.sql -b /home/pjayasan -c ora2pg.conf

Thanks in Advance!!!

Oct 25 '21 03:10 pjayasan

This is probably because Ora2Pg only export users that have privileges on the database objects. I will have a look.

Oct 25 '21 05:10 darold

Is there any ways to export all the users available in oracle??

Oct 25 '21 15:10 pjayasan

Not yet, I will try to allow that in Ora2Pg in the week.

Oct 25 '21 15:10 darold

Any update on this??

Nov 09 '21 14:11 pjayasan

Not for the moment, actually this is not a high priority and as you can see there is lot of issues asking for enhancement.

Nov 11 '21 17:11 darold