Kbase P26811: After running protoora utility, schema holder does not conta
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/23/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
SYMPTOM(s):
Tables/objects are not created within schema holder
Ran Protoora utility
Data is not loaded into Oracle database
Both "Load SQL" option is selected during protoora
"Load data" option is selected during protoora
Oracle database is local
Migration was run under ORACLE user 'sys'.
CAUSE:
The issue is related to user privileges
FIX:
1. Create a new user in ORACLE
2. Make sure that user has correct SELECT privs outlined in 3.7.1 Schema-holder Security. This should allow the migration tool to pull back the tables into the SH and load the data into ORACLE.
Table 3-7: Required ORACLE Permissions
PERMISSIONS OBJECT
==========================
CREATE SESSION Database
SELECT System objects:
sys.argument$
sys.col$
sys.com$
sys.con$
sys.dual
sys.icol$
sys.ind$
sys.link$
sys.obj$
sys.procedure$
sys.seq$
sys.syn$
sys.tab$
sys.user$
sys.view$