0701002-oracle创建用户及表空间

0701002-oracle创建用户及表空间

1.创建表空间

create BIGFILE TABLESPACE NBILLING DATAFILE '/u01/app/oracle/oradata/orcl11gr2/nbilling01.dbf' SIZE 1G AUTOEXTEND on next 1G MAXSIZE 30G NOLOGGING;

2.创建用户

create user BILL IDENTIFIED by BILL default TABLESPACE NBILLING;

GRANT connect, resource, DBA to BILL;

嗯，环境搭好了。

4.参考

• [http://docs.oracle.com/cd/E11882_01/server.112/e41084/toc.htm]

0.修订记录

class nobody{
public:
	string author    = "zhiw";
	string email     = "zhiw2019#163.com"
	string timestamp = "2015年2月10日"
	string version   = "000,初始发布"
};