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]