Question

plsql怎么创建表空间

Answer 1

新建表空间，登录名和密码
--请尽量把表空间和别的系统分离，这里以Search为例子，登录名和密码以test为例子
create tablespace Search
logging
datafile 'D:\oracle\product\10.2.0\oradata\orcl\Search.ora' size 15M extent
management local segment space management auto;
--删除test用户
drop user test cascade;
--创建test用户
create user test
identified by test
default tablespace Search
temporary tablespace TEMP;
--为用户授权
grant connect,resource,dba to test;
commit;
--修改表空间大小
ALTER DATABASE DATAFILE 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\Search.ora' AUTOEXTEND ON NEXT 15K MAXSIZE UNLIMITED;
commit;
plsql远程查看表空间创建路径
select *from dba_data_files