I need to duplicate a Oracle 11g Express Edition database from one computer to another computer.
exp sys/password FULL=Y FILE=backup.dump (the idea is to do a imp on the other pc)
But it gaves me the following error:
EXP-00008: ORACLE error 12704 encountered ORA-12704: character set mismatch ORA-06512: at "SYS.DBMS_SERVER_ALERT_EXPORT", line 10 ORA-06512: at "SYS.DBMS_SERVER_ALERT_EXPORT", line 118 ORA-06512: at line 1
How can I make a full, complete backup with usernames, passwords, everything to be loaded into another host?