E
E
Evgeny Komarov2014-04-29 12:49:50
Oracle
Evgeny Komarov, 2014-04-29 12:49:50

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;

or will it be necessary to dance with a tambourine after? Share your experience.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexey Lesovsky, 2014-04-29
@lesovsky

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 question

Ask a Question

731 491 924 answers to any question