10g中如何修改数据库字符集-1

最新推荐文章于 2021-04-09 00:33:43 发布

转载最新推荐文章于 2021-04-09 00:33:43 发布 · 116 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/ebs-blog/archive/2011/07/19/2167240.html

文章标签：

#数据库

本文展示了 Oracle 10g 数据库的基本操作，包括环境信息查询、用户权限设置、表创建及数据插入等，并详细记录了 CSScan 工具的安装与配置过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SQL> !uname -a

Linux roger 2.6.9-42.ELsmp #1 SMP Wed Jul 12 23:27:17EDT 2006 i686 i686 i386 GNU/Linux

SQL> select userenv('language') from dual;

USERENV('LANGUAGE')

----------------------------------------------------

AMERICAN_AMERICA.WE8ISO8859P1

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release10.2.0.4.0 - Prod

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for Linux: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

SQL> conn roger/roger

Connected.

SQL> create table ht01(id number,name varchar2(6));

Table created.

SQL> insert into ht01 values(1,'海天');

1 row created.

SQL> insert into ht01 values(2,'北京');

1 row created.

SQL> commit;

Commit complete.

SQL>

SQL> select * from ht01;

ID NAME

---------- ------

1 ????

2 ????

SQL>

安装配置csscan

SQL> @?/rdbms/admin/csminst.sql

grant READ on directory log_file_dir to system

ERROR at line 1:

ORA-22930: directory does not exist

grant READ on directory data_file_dir to system

ERROR at line 1:

ORA-22930: directory does not exist

drop user csmig cascade

ERROR at line 1:

ORA-01918: user 'CSMIG' does not exist

Please create password for user CSMIG:

Enter value for csmig_passwd: csmig

old 1: createuser csmig identified by &csmig_passwd

new 1: createuser csmig identified by csmig

User created.

Grant succeeded.

User altered.

1 row created.

1 row updated.

Table created.

drop public synonym csm$parameters

ERROR at line 1:

ORA-01432: public synonym to be dropped does not exist

Synonym created.

Grant succeeded.

Table created.

drop public synonym csm$query

ERROR at line 1:

ORA-01432: public synonym to be dropped does not exist

Synonym created.

Grant succeeded.

Table created.

drop public synonym csm$tables

ERROR at line 1:

ORA-01432: public synonym to be dropped does not exist

Synonym created.

Grant succeeded.

Table created.

drop public synonym csm$columns

ERROR at line 1:

ORA-01432: public synonym to be dropped does not exist

Synonym created.

Grant succeeded.

Table created.

drop public synonym csm$extables

ERROR at line 1:

ORA-01432: public synonym to be dropped does not exist

Synonym created.

Grant succeeded.

Table created.

drop public synonym csm$errors

ERROR at line 1:

ORA-01432: public synonym to be dropped does not exist

Synonym created.

Grant succeeded.

Table created.

drop public synonym csm$langid

ERROR at line 1:

ORA-01432: public synonym to be dropped does not exist

Synonym created.

Grant succeeded.

Table created.

drop public synonym csm$charsetid

ERROR at line 1:

ORA-01432: public synonym to be dropped does not exist

Synonym created.

Grant succeeded.

Table created.

drop public synonym csm$indexes

ERROR at line 1:

ORA-01432: public synonym to be dropped does not exist

Synonym created.

Grant succeeded.

Table created.

drop public synonym csm$constraints

ERROR at line 1:

ORA-01432: public synonym to be dropped does not exist

Synonym created.

Grant succeeded.

Table created.

drop public synonym csm$triggers

ERROR at line 1:

ORA-01432: public synonym to be dropped does not exist

Synonym created.

Grant succeeded.

Table created.

drop public synonym csm$dictusers

ERROR at line 1:

ORA-01432: public synonym to be dropped does not exist

Synonym created.

Grant succeeded.

14 rows created.

View created.

drop public synonym csmv$tables

ERROR at line 1:

ORA-01432: public synonym to be dropped does not exist

Synonym created.

View created.

drop public synonym csmv$columns

ERROR at line 1:

ORA-01432: public synonym to be dropped does not exist

Synonym created.

View created.

drop public synonym csmv$errors

ERROR at line 1:

ORA-01432: public synonym to be dropped does not exist

Synonym created.

View created.

drop public synonym csmv$indexes

ERROR at line 1:

ORA-01432: public synonym to be dropped does not exist

Synonym created.

View created.

drop public synonym csmv$constraints

ERROR at line 1:

ORA-01432: public synonym to be dropped does not exist

Synonym created.

View created.

drop public synonym csmv$triggers

ERROR at line 1:

ORA-01432: public synonym to be dropped does not exist

Synonym created.

View created.

Grant succeeded.

Commit complete.

Disconnected from Oracle Database 10g EnterpriseEdition Release 10.2.0.4.0 - Production

With the Partitioning, OLAP, Data Mining and RealApplication Testing options

[oracle@roger ~]$

转载于:https://www.cnblogs.com/ebs-blog/archive/2011/07/19/2167240.html