oracle导出导入数据和创建用户以及授权命令

     su - oracle

     sqlplus / as sysdba;

     SQL> conn / as sysdba;

　　SQL>create user username identified by password

　　SQL> grant dba to username;

　　SQL> conn username/password

　　SQL> select * from user_sys_privs;

     CMD导出oracle数据库命令

SQL>exp 用户名/密码@localhost:1521/实例名file=路径.dmp

SQL>exp alxacrm/alxacrm@192.168.100.126:1521/gsdb file=D:alxacrm.dmp;

SQL>impalxacrm/alxacrm@192.168.100.126:1521/gsdb file=D:alxacm.dmp full=y;

    查看linux oracle server端的字符集

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

    或者SQL> select * from V$NLS_PARAMETERS;

    或者SQL> select * from nls_database_parameters where parameter like 'NLS%CHARACTERSET';