This is the code that runs to generate the database. I plan on removing the CHARACTER SET "WE8ISO8859P1" and NATIONAL CHARACTER SET "UTF8" lines. This should cause the character sets to line up between the database and client. Is there a better solution than this?
Code:set echo on set feedback on set termout on set timing on startup nomount pfile = "\\pfile\init.ora" CREATE DATABASE "" MAXINSTANCES 1 MAXDATAFILES 254 MAXLOGFILES 32 CHARACTER SET "WE8ISO8859P1" NATIONAL CHARACTER SET "UTF8" DATAFILE '\\system_01.dbf' SIZE 500M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED UNDO TABLESPACE UNDO_TS DATAFILE '\\undo_01.dbf' SIZE 1000M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '\\temp_01.dbf' SIZE 1200M UNIFORM SIZE 1M EXTENT MANAGEMENT LOCAL LOGFILE GROUP 1 ('\\redo_01a.log') SIZE 100M, GROUP 2 ('\\redo_02a.log') SIZE 100M, GROUP 3 ('\\redo_03a.log') SIZE 100M, GROUP 4 ('\\redo_04a.log') SIZE 100M, GROUP 5 ('\\redo_05a.log') SIZE 100M, GROUP 6 ('\\redo_06a.log') SIZE 100M, GROUP 7 ('\\redo_07a.log') SIZE 100M, GROUP 8 ('\\redo_08a.log') SIZE 100M, GROUP 9 ('\\redo_09a.log') SIZE 100M; GROUP 10 ('\\redo_10a.log') SIZE 100M; spool off @@cre_dict.sql




Reply With Quote