创建表空间及plsql查看远程表空间路径

-新建表空间，登录名和密码 --请尽量把表空间和别的系统分离，这里以Search为例子，登录名和密码以test为例子 create tablespace Search logging datafile 'D:oracleproduct10.2.0oradataorclSearch.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:ORACLEPRODUCT10.2.0ORADATAORCLSearch.ora' AUTOEXTEND ON NEXT 15K MAXSIZE UNLIMITED; commit;

plsql远程查看表空间创建路径 select *from dba_data_files