We are using STAT 5.7.4 for our Oracle R12 migrations. Currently we are migrating DB grants manually and want to leverage STAT for this purpose. For all other objects like tables, procedures, packages etc. we are using STAT. But not sure how to migrate grants.
Thanks
Santosh
Hi Tom,
Below is how I created custom file object type.
I placed the xxea_grant_stmt.sh file in our custom top and below is the code in it. When migrating I am getting 'OA Generation Error'. What could be the issue?
#!/bin/bash
#
echo "The shell script execution starts "
echo $1
exit | sqlplus system/$2 @$1 >/tmp/$1.log
echo "exit"
echo "Completed execution"
date
Hi Tom,
Below is how I created custom file object type.
I placed the xxea_grant_stmt.sh file in our custom top and below is the code in it. When migrating I am getting 'OA Generation Error'. What could be the issue?
#!/bin/bash
#
echo "The shell script execution starts "
echo $1
exit | sqlplus system/$2 @$1 >/tmp/$1.log
echo "exit"
echo "Completed execution"
date
