--表空间
CREATE
TABLESPACE
TS_HIP
DATAFILE
'/home/oracle/oracleDBSpace/XXX.dbf'
size
30720
M
EXTENT
MANAGEMENT
LOCAL
SEGMENT
SPACE
MANAGEMENT
AUTO
;
--索引表空间
CREATE
TABLESPACE
TS_HIP_Index
DATAFILE
'/home/oracle/oracleDBSpace/XXX_index.dbf'
size
512
M
EXTENT
MANAGEMENT
LOCAL
SEGMENT
SPACE
MANAGEMENT
AUTO
;
--删除表空间
--drop tablespace DEMOSPACE including contents and datafiles
---删掉用户
--drop user username cascade;
--创建用户组
--2.建用户
create
user
username
identified
by
password
default
tablespace
tablespace;
--修改密码
alter
user
username
identified
by
newPassword;
--3.赋权
grant
connect
,
resource
,
dba
to
username;
grant
create
any
sequence
to
username;
grant
create
any
table
to
username;
grant
delete
any
table
to
username;
grant
insert
any
table
to
username;
grant
select
any
table
to
username;
grant
unlimited
tablespace
to
username;
grant
execute
any
procedure
to
username;
grant
update
any
table
to
username;
grant
create
any
view
to
username;
---修改oracle数据字符集操作
select
*
from
nls_database_parameters t
where
t.parameter=
'NLS_CHARACTERSET'
;
update
props$
set
value$=
'AMERICAN'
WHERE
NAME
=
'NLS_LANGUAGE'
;
update
props$
set
value$=
'AMERICA'
WHERE
NAME
=
'NLS_TERRITORY'
;
update
props$
set
value$=
'$'
WHERE
NAME
=
'NLS_CURRENCY'
;
update
props$
set
value$=
'AMERICA'
WHERE
NAME
=
'NLS_ISO_CURRENCY'
;
update
props$
set
value$=
'ZHS16GBK'
WHERE
NAME
=
'NLS_CHARACTERSET'
;
update
props$
set
value$=
'AMERICAN'
WHERE
NAME
=
'NLS_DATE_LANGUAGE'
;
update
props$
set
value$=
'$'
WHERE
NAME
=
'NLS_DUAL_CURRENCY'
;
update
props$
set
value$=
'AL16UTF16'
WHERE
NAME
=
'NLS_NCHAR_CHARACTERSET'
;
commit
;
--停止数据库
SQL
>
shutdown
immediate
--重启数据库服务
SQL
> startup
mount
--删除一个字段
alter
table
表名
drop
column
字段名;
--修改一个字段
alter
table
表名
rename
column
字段名
to
新的字段名;
--添加一个字段
alter
table
表名
add
(字段名 类型 );