/*第1步:创建临时表空间 */
create temporary tablespace emaoyi_temp? tempfile ‘D:appAdministratorproduct11.2.0dbhome_1databaseemaoyi_temp.dbf‘? size 10m? autoextend on? next 10m maxsize 20480m? extent management local;?
/*第2步:创建数据表空间 */
create tablespace emaoyi? logging? datafile ‘D:appAdministratorproduct11.2.0dbhome_1databaseemaoyi.dbf‘? size 10m? autoextend on? next 10m maxsize 20480m? extent management local;?
/*第3步:创建用户并指定表空间 */
create user emaoyi identified by emaoyi? default tablespace emaoyi temporary tablespace emaoyi_temp;?
/*第4步:给用户授予权限 */
grant connect,resource,dba to emaoyi;
--查询当前表空间
select tablespace_name,file_id,file_name,bytes from dba_data_files order by file_id
where tablespace_name=‘emaoyi‘
--删除表空间drop tablespace em;--删除用户drop user e [CASCADE];
(编辑:李大同)
【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!
|