启动database configuration assistant,创建数据库,参照下面的图释。
这里指定数据库名和实例名,根据自己想要的设置,这里是举例啦
可以统一的口令,也可以选上面的选项进行逐一设置
可以在这里设置字符集,后面的步骤默认即可。有问题再追问吧。
查看及修改oracle编码格式方法:\x0d\x0a1、查看oracle数据库字符集:\x0d\x0aselect userenv('language') from dual\x0d\x0a查询结果:\x0d\x0aSIMPLIFIED CHINESE_CHINA.AL32UTF8\x0d\x0a2、修改oracle数据库字符集:(在SQL Plus中)\x0d\x0asql>conn / as sysdba\x0d\x0asql>shutdown immediate\x0d\x0adatabase closed.\x0d\x0adatabase dismounted.\x0d\x0aoracle instance shut down.\x0d\x0asql>startup mount\x0d\x0aoracle instance started.\x0d\x0atotal system global area 135337420 bytes\x0d\x0afixed size 452044 bytes\x0d\x0avariable size 109051904 bytes\x0d\x0adatabase buffers 25165824 bytes\x0d\x0aredo buffers 667648 bytes\x0d\x0adatabase mounted.\x0d\x0asql>alter system enable restricted session\x0d\x0asystem altered.\x0d\x0asql>alter system set job_queue_processes=0\x0d\x0asystem altered.\x0d\x0asql>alter system set aq_tm_processes=0\x0d\x0asystem altered.\x0d\x0asql>alter database open\x0d\x0adatabase altered.\x0d\x0asql>alter database character set internal_use UTF8\x0d\x0asql>shutdown immediate\x0d\x0asql>startup欢迎分享,转载请注明来源:内存溢出
评论列表(0条)