oracle基础操作以及修改字符集

连接，配置，导入，函数，字符集

conn sys/xxx as sysdba
create user xxx identified by xxx
grant dba to xxx
SHUTDOWN IMMEDIATE
STARTUP MOUNT
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE OPEN;
ALTER DATABASE CHARACTER SET INTERNAL_USE ZHS16GBK;
SHUTDOWN IMMEDIATE
STARTUP

connect xxx/xxx
ALTER SESSION SET CURRENT_SCHEMA = xxx;

imp xxx/xxx@localhost/xe fromuser=xxx touser=xxx log=no file=（dmp的路径）/xxx.dmp

查看函数和字符集：

select object_name from user_objects where object_type='FUNCTION';
select * from nls_session_parameters

修改charset：

export NLS_LANG=AMERICAN_AMERICA.UTF8
export LANG=en_US.UTF-8