Kbase P68083: Protoora does not bring the tables from the oracle database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
24/02/2004 |
|
Status: Unverified
SYMPTOM(s):
Protoora does not bring the tables from the oracle database after successfully being completed.
No error massage is displayed
Used oracle dba user "system" to connect to the database during the protoora process
CAUSE:
Protoora process filters out any tables that owns by a user with "SYS" prefix. Therefore no objects will be brought up in to the schema holder during the protoora process, hence, an empty schema holder will be created.
FIX:
Use a different user name with appropriate privileges as described in chapter 3 of the Oracle DataServer Guide.