一、以sysdba身份登录Oracle系统 sqlplus conn/ as sysdba 二、关闭数据库,停止数据库服务 SQL>shutdown immediate; 三、启动Oracle例程 SQL> startup mount; Total System Global Area 612****84 bytes Fixed Size 125****52 bytes Variable Size 176****92…
更改Oracle字符集:把字符集ZHS16GBK换成UTF8 SQL> select name,value$ from props$ where name like %NLS%; NAME VALUE$ ------------------------------ ------------------------------ NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CURRENCY $ NLS_ISO_…