Answer the question
In order to leave comments, you need to log in
How to transfer the database by converting data in tables?
Is available Oracle EE 11gR2 and in it. Encoding of all schemas and tables CL8MSWIN1251. How can you transfer part of the schemes to another server as simply and painlessly as possible, with the conversion of the available information in the tables into the AL32UTF8 encoding.
Will it be enough to run the script after deploying the data, which is in the docks
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE OPEN;
ALTER DATABASE CHARACTER SET INTERNAL_USE AL32UTF8;
ALTER DATABASE CHARACTER SET AL32UTF8;
SHUTDOWN IMMEDIATE;
STARTUP;
Answer the question
In order to leave comments, you need to log in
deploy the database backup somewhere aside and practice, so you yourself will find out everything
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question