查看数据文件位置
select tablespace_name, file_id,file_name,
round(bytes/(1024*1024),0) total_space from dba_data_files order by tablespace_name;
创建表空间
create tablespace NETRES_TX
datafile 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\NETRES_TX'
size 20m reuse default
storage(Initial 64K Next 128K MinExtents 2 MaxExtents Unlimited PctIncrease 0 );
create user NETRES_TX identified by NETRES_TX default tablespace NETRES_TX;
grant connect , resource,dba to NETRES_TX;
grant execute on dbms_pipe to NETRES_TX;
grant create trigger , create view, create synonym, unlimited tablespace to NETRES_TX;