Kbase P11560: Objects not seen after a database migration from Progress to Oracle
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
SYMPTOM(s):
Objects not seen after a database migration from Progress to Oracle
"protoora" run as user "system"
Oracle tables created in tablespace TOOLS
CAUSE:
It is written within our documentation, below Table 5.9: Progress-to-ORACLE Utility
1. Create a target ORACLE database. You must use an empty ORACLE database when you run the Progress-to-ORACLE utility
What is called an "empty Oracle database" is an "empty schema within Oracle database".
FIX:
Create a new user; run "protoora" as that user with an empty schema within Oracle.
Example for creating an Oracle user, while having a tablespace "USERA":
CREATE USER expert IDENTIFIED BY expert
DEFAULT TABLESPACE USERA;
GRANT dba TO expert;