MIGRATION: Test import of Database
Test import of intranet Database for migration with new Character set on Unix (Source Windows).
FROMCHAR WE8MSWIN1252
TOCHAR WE8ISO8859P15
CSSCAN lists many lossy characters. Decided with developers to just try what happens.
Errors:
ORA-19815, ORA-16038, ORA-19809:
db_recovery_file_dest_size (online changeable) was set to 4GB, which let the import get stuck when the archive logfiles filled that space up. Extended to 8 GB.
Note to self: Disable archivelog mode if creating a new DB with import.
FROMCHAR WE8MSWIN1252
TOCHAR WE8ISO8859P15
CSSCAN lists many lossy characters. Decided with developers to just try what happens.
Errors:
ORA-19815, ORA-16038, ORA-19809:
db_recovery_file_dest_size (online changeable) was set to 4GB, which let the import get stuck when the archive logfiles filled that space up. Extended to 8 GB.
Note to self: Disable archivelog mode if creating a new DB with import.
Labels: character set, db_recovery_file_dest_size, export, Import, migration, ORA-16038, ORA-19809, ORA-19815, oracle
posted by Dröli at 6:02 AM
0 Comments:
Post a Comment
<< Home