In the data migration needs to make the source and target database of the character set, version and other information unified ...
Here is the setting for a database that requires the same action on both sides.
[Email protected]> Select Userenv (' language ') from dual;
USERENV (' LANGUAGE ')
----------------------------------------------------
American_america. Zhs16gbk
[Email protected]> startup Mount
ORACLE instance started.
Total System Global area 638853120 bytes
Fixed Size 2255952 bytes
Variable Size 255853488 bytes
Database buffers 373293056 bytes
Redo buffers 7450624 bytes
Database mounted.
[Email protected]> ALTER SESSION SET sql_trace=true;
Session altered.
[Email protected]> ALTER SYSTEM SET job_queue_processes=0;
System altered.
[Email protected]> ALTER SYSTEM SET aq_tm_processes=0;
System altered.
[Email protected]>
[Email protected]>
[Email protected]> ALTER SYSTEM ENABLE RESTRICTED SESSION;
System altered.
[Email protected]> ALTER DATABASE open;
Database altered.
[Email protected]> ALTER DATABASE character set Internal_use we8mswin1252;
Database altered.
[Email protected]> alter system disable restricted session;
System altered.
[Email protected]> execute sys.dbms_metadata_util.load_stylesheets;
PL/SQL procedure successfully completed.
[Email protected]> Select Userenv (' language ') from dual;
USERENV (' LANGUAGE ')
--------------------------------------------------------------------------------
American_america. we8mswin1252
To view the changes, we need to change the previously modified parameters back:
[Email protected]> alter system set JOB_QUEUE_PROCESSES=30;
System altered.
[Email protected]> alter system set Aq_tm_processes=1;
Reboot (forced restart in experimental environment)
[Email protected]> startup force;
ORACLE instance started.
Total System Global area 638853120 bytes
Fixed Size 2255952 bytes
Variable Size 255853488 bytes
Database buffers 373293056 bytes
Redo buffers 7450624 bytes
Database mounted.
Database opened.
Complete ~
Oracle Database Change Character Set