|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
导入dmp
imp userid=eos/eos@192.168.1.93/orcl file=/home/oracle/eos.dmp
查看用户
select
username
from
dba_users;
环境变量
ORACLE_HOME=/data/oracle/product/11.2.0/db_1/bin/
查询服务端字符集
select
*
from
nls_database_parameters
where
parameter=
'nls_characterset'
;
select
*
from
nls_database_parameters
where
parameter=
'NLS_CHARACTERSET'
;
select
userenv(
'language'
)
from
dual;
ZHS16GBK
查看dmp字符集
select
nls_charset_name(to_number(
'0354'
,
'xxxx'
))
from
dual;
授权
GRANT
CREATE
USER
,
DROP
USER
,
ALTER
USER
,
CREATE
ANY
VIEW
,
DROP
ANY
VIEW
,
EXP_FULL_DATABASE,IMP_FULL_DATABASE,
DBA,
CONNECT
,RESOURCE,
CREATE
SESSION
TO
BBRUN;
|
本文转自 yntmdr 51CTO博客，原文链接：http://blog.51cto.com/yntmdr/1944282，如需转载请自行联系原作者
