Hello, I am using MaxDB version 7.6.00 Build 016-123-109-428.
I am trying to duplicate a schema (user), by exporting it and then
reimporting into a different user. In short, to copy a user's objects
and data into the same database instance. My catalog script contains a
pair of grants refering to the original schema (SECURITY), the new
schema/user is SECURITYD. I don't know if that can prevent the process
from reaching success.
Here is the error message printed by the loader:
User SECURITYD connected to database PROD schema SECURITYD on local host.
TABLELOAD USER
CATALOG INSTREAM 'C:\servers\maxdb\luis-cat.dat'
DATA INSTREAM 'C:\servers\maxdb\luis-data.dat'
Error during execution
-->-25392
'[MySQL MaxDB][SQLOD32 DLL][MaxDB] Base table not found;-4004 POS(26) Unknown ta
ble name:S_USER'
Loader log:
// M Loader 7.6.00 Build 016-123-109-428
// *
// M Module: c:\archivos de programa\sdb\programs\bin\loadercli.exe
// *
// M Loader instance started at MARTIN for database PROD
// *
// M Starting protocol at 2006030800131116
// *
// M START 20060308 00131116
// *
SET
// *
// M START 20060308 00131116
// *
USE USER "SECURITYD" * SCHEMA SECURITYD SERVERDB "PROD"
// *
// M USER: 'SECURITYD' on DB: 'PROD' ISOLATION LEVEL: 3
// *
// M START 20060308 00131116
// *
TABLELOAD USER
CATALOG INSTREAM 'C:\servers\maxdb\luis-cat.dat'
DATA INSTREAM 'C:\servers\maxdb\luis-data.dat'
// *
// M Execute PACKAGE to transform CATALOG
/ *
GRANT SELECT ON SECURITY.S_USER TO SOPORTE
// *
// E -25392: '[MySQL MaxDB][SQLOD32 DLL][MaxDB] Base table not
found;-4004 POS(26) Unknown table name:S_USER'
// M Number of TABLES transformed : 0
// *
The user SECURITY and the table S_USER exists in the same instance,
but the one in which I am trying to import is called "SECURITYD". What
can I do to make it work?
Thanks for your help,
Martin
--
Dinamica - RADical J2EE framework
open source, easy and powerful
http://www.martincordova.com
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
