exp 命令行模式:
1.导出表:
$ exp \'sys/Lin630xxxx as sysdba\' tables=SYS.STUDENTS,SYS.TEST1 GRANTS=y file='/u01/app/admin/HAITIAN/dpdump/expdat.dmp'
2.导出用户所有表:
$ exp \'sys/Linxxxx as sysdba\' owner=GIS file='/u01/app/admin/HAITIAN/dpdump/expdat.dmp'
数据泵模式导出:
#create directory DATA_PUMP_DIR as '/u01/app/oracle/product/11.2.0/db_1/rdbms/log/';
1.全库导出:
$ expdp \'sys/Lin630xxxx@racdb as sysdba\' dumpfile=full.dmp logfile=full.log full=y directory=DATA_PUMP_DIR
2.用户导出:
$ expdp \'sys/Lin630xxxx@racdb as sysdba\' dumpfile=sys_user.dmp logfile=sys_user.log owner=sys directory=DATA_PUMP_DIR
3.表导出:
$ expdp \'sys/Lin630xxxx@racdb as sysdba\' dumpfile=sys_table_test1.dmp logfile=sys_table_test1.log tables=test1 directory=DATA_PUMP_DIR
$ expdp \'sys/Lin630xxxx as sysdba\' dumpfile=sys_table_test1.dmp logfile=sys_table_test1.log tables=GIS.test1 directory=DATA_PUMP_DIR
4.表带查询条件导出:
$ expdp \'sys/Lin630xxxx@racdb as sysdba\' dumpfile=sys_table_test1.dmp logfile=sys_table_test1.log tables=test1 directory=DATA_PUMP_DIR query="'where ROWNUM<3'"
5.表空间导出:
$ expdp \'sys/Lin630xxxx as sysdba\' dumpfile=sys_tablespace_AGILE.dmp tablespaces=AGILE logfile=sys_tablespace_AGILE.log directory=DATA_PUMP_DIR
$ expdp \'sys/Lin630xxxx@racdb as sysdba\' dumpfile=sys_tablespace_st01.dmp logfile=sys_tablespace_st01.log tablespaces=ST01 directory=DATA_PUMP_DIR
数据泵模式导入:
1.表空间导入:
$ impdp \'sys/Lin630xxxx as sysdba\' directory=DATA_PUMP_DIR dumpfile=sys_tablespace_AGILE.dmp tablespaces=AGILE
2.表导入:
$ impdp \'sys/Lin630xxxx as sysdba\' directory=DATA_PUMP_DIR dumpfile=sys_table_test1.dmp tables=GIS.test1
3.用户导入:
$ impdp \'sys/Lin630xxxx as sysdba\' dumpfile=GIS_user.dmp schemas=GIS directory=DATA_PUMP_DIR
4.全库导入:
impdp \'sys/Lin630xxxx as sysdba\' dumpfile=full.dmp directory=DATA_PUMP_DIR full=y
字符集:
查看Oracle服务端字符集:
SQL> select t.name,t.value$,t.rowid from sys.props$ t where name='NLS_LANGUAGE' or name='NLS_CHARACTERSET' or name like 'NLS_TERRITORY';
字符集格式:
NLS_LANGUAGE,NLS_TERRITORY,NLS_CHARACTERSET
设置Oracle服务端字符集:
SQL> update sys.props$ set value$='SIMPLIFIED CHINESE' where name='NLS_LANGUAGE';
SQL> commit;
SQL> update sys.props$ set value$='ZHS16GBK' where name='NLS_CHARACTERSET';
SQL> commit;
SQL> update sys.props$ set value$='CHINA' where name='NLS_TERRITORY';
SQL> commit;
再查看服务器端字符集:
SQL> select * from nls_database_parameters where parameter in ('NLS_LANGUAGE','NLS_TERRITORY','NLS_CHARACTERSET','NLS_NCHAR_CHARACTERSET');
SQL> select * from v$nls_parameters;
SQL> select * from nls_database_parameters;
SQL> select * from sys.props$;
查看客户端的字符集:
SQL> select userenv('language') from dual;
SQL> select * from nls_instance_parameters;
设置sqlplus窗口字符集:
SQL> startup mount;
SQL> alter system enable restricted session;
SQL> alter system set JOB_QUEUE_PROCESSES=0;
SQL> alter system set AQ_TM_PROCESSES=0;
SQL> alter database open;
SQL> alter database character set internal_use ZHS16GBK;
SQL> shutdown immediate;
SQL> startup;
#echo 'export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"'>> /etc/profile
#source /etc/profile
sqlplus乱码与操作系统NLS_LANG变量有关。
PL/SQL 字符集乱码与PL/SQL软件--工具--首选项里面的设置的语言环境有关。
secureCRT 设置中文:
1.菜单--终端--仿真--终端选择Linux并勾选ANSI颜色。
2.菜单--外观--标准字体--选择新宋体,常规,三号,字符集:中文GB2312.
3.菜单--外观--字符编码选UTF-8,并且去掉使用Unicode线条绘制字符前的对勾。
声明:我要去上班所有作品(图文、音视频)均由用户自行上传分享,仅供网友学习交流,版权归原作者王啸皓月山巅所有,原文出处。若您的权利被侵害,请联系删除。
本文标题:(sql中的nchar什么意思)(sql nchar和char)
本文链接:https://www.51qsb.cn/article/m8gta.html