oracle 创建用户 远程登入, 初始化表空间

默认密码: scott/tiger

我设置的 : system /123456

一.oracle11g 启动远程服务器

http://blog.sina.com.cn/s/blog_7c0e26230100t0ci.html

# listener.ora Network Configuration File: C:appAdministratorproduct11.2.0dbhome_1networkadminlistener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:appAdministratorproduct11.2.0dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:appAdministratorproduct11.2.0dbhome_1binoraclr11.dll")
)
(SID_DESC =
(SID_NAME = ORCL)
(ORACLE_HOME = C:appAdministratorproduct11.2.0dbhome_1)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = SD-201609021212)(PORT = 1521))
)
)

ADR_BASE_LISTENER = C:appAdministrator

1.创建帐号- system帐号登入

createusercgidentifiedbycg123;--新建用户
GRANTCONNECT,RESOURCE,DBATOcg;--赋予权限

create user  drawdh  identified by drawdh;
 
 grant connect,resource,dba to drawdh;

2. 创建表空间

-- 创建表空间 linux
create tablespace JUNHEIT datafile '${ORACLE_HOME}oradatanotifydb.dbf' size 100M reuse autoextend on next 40M maxsize unlimited default storage(initial 128k next 128k minextents 2 maxextents unlimited);	
--- 查询当前用户所属的 表空间
select username,default_tablespace from user_users;
-- 查看所有的表空间
select tablespace_name from dba_tablespaces;

http://jingyan.baidu.com/article/90bc8fc80c01f2f653640c1f.html

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!