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

最新推荐文章于 2024-06-17 20:12:26 发布

weixin_34365635

最新推荐文章于 2024-06-17 20:12:26 发布

阅读量605

点赞数

文章标签：数据库操作系统 python

原文链接：https://my.oschina.net/u/1760858/blog/741375

版权

2019独角兽企业重金招聘Python工程师标准>>>

默认密码: scott/tiger

我设置的 : system /123456

一.oracle11g 启动远程服务器

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

# listener.ora Network Configuration File: C:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
(SID_DESC =
(SID_NAME = ORCL)
(ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_1)
)
)

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

ADR_BASE_LISTENER = C:\app\Administrator

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

create user cg identified by cg123; --新建用户
GRANT CONNECT,RESOURCE,DBA TO cg ; --赋予权限
 create user  drawdh  identified by drawdh;
 
 grant connect,resource,dba to drawdh;

2. 创建表空间

-- 创建表空间 linux
create tablespace JUNHEIT datafile '${ORACLE_HOME}\oradata\notifydb.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;