I'm trying to move a database from one server to another, so I died something like writen in the migration how to.
First I execute the script:
SET MAXERRORCOUNT 1
//
USE USER dba_user dba_pass SERVERDB comtecdb ON localhost
//
DBEXTRACT CATALOG OUTSTREAM FILE 'c:\db\comtec.cat' DATA OUTSTREAM FILE c:\db\comtec.data'
//
with the command
repmcli.exe -u SYSDBA,<passwd> -d <dbname> -n <host> -E 1 -b <script>
this ran without any erros.
Then for import I used the script:
SET MAXERRORCOUNT 1
//
USE USER dba_user dba_pass SERVERDB tst2 ON 130.83.197.34
//
DBLOAD CATALOG INSTREAM FILE 'c:\db\comtec.cat' DATA INSTREAM FILE 'c:\db\comtec.data0001'
Again without errors.
In the Database are several tables owned by comtecdba.
When I look at the new database with SQL Tool I can the the users from the old location but no tables.
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
