Kbase P49608: No reference to sys.ts$ system object causes error 6483 when running Progress-to-Oracle migration to
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1x
ORACLE DataServer
SYMPTOM(s):
Progress database to ORACLE utility fails
Progress-to-Oracle migration utility does not complete
prowin32 client gets error 6483
Please also verify you have SELECT privileges on the needed system tables
and the proper version of ORACLE (7 or 8) was selected when the schema
holder was created (328) (6483)
_progres client gets no errors, it is returned to Data Dictionary menu
Following permissions are assigned to ORACLE user
-CREATE SESSION, CREATE TABLE, CREATE SEQUENCE on database objects
-SELECT against all 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$
-Enough quota within default table space
The above list of permissions are documented in
3.7.1 Schema-holder Security
Permissions for Creating a Schema Holder
V9.xProgress DataServer for ORACLE Guide
By enabling -Dsrv qt_debug,SQL, the following SQL is listed when error is received
SELECT /*+ ROWID(T0) */ TS#,NAME,OWNER#,ONLINE$,UNDOFILE#,UNDOBLO CK#,BLOCKSIZE,INC#,SCNWRP,SCNBAS,DFLMINEXT,DFLMAXEXT,DFLINIT,DFLI
NCR,DFLEXTPCT FROM sys.ts$ T0
Select permission to the sys.ts$ system object is made.
CAUSE:
Documentation bug. sys.ts$ is the Oracle Tablespace table which has been being
used during schema creation and should be put into the documentation
FIX:
Select permission for "SYS"."TS$" is needed for schema creation
Grant SELECT ON "SYS"."TS$";
Example syntax;
GRANT SELECT ON "SYS"."TS$" TO "SCOTT";
The referenced bug is fixed in R10.0A documentation.