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]

Reply via email to