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';