http://127.0.0.1:1158/em
create temporary tablespace sfsj_temp
tempfile 'C:\oracle\product\10.2.0\oradata\orcl\sfsj_temp.dbf'
size 50m
autoextend on
next 50m maxsize unlimited
extent management local;
create tablespace sfsj_data
logging
datafile 'C:\oracle\product\10.2.0\oradata\orcl\sfsj_data.dbf'
size 50m
autoextend on
next 50m maxsize unlimited
extent management local;
create user sfsj identified by sfsj
default tablespace sfsj_data
temporary tablespace sfsj_temp;
grant connect,resource,dba to sfsj;
alter tablespace sfsj_data add datafile 'C:\oracle\product\10.2.0\oradata\orcl\sfsj_data02.dbf'
size 200M
autoextend on
next 50m maxsize unlimited;
alter tablespace sfsj_data drop datafile 'C:\oracle\product\10.2.0\oradata\orcl\sfsj_data02.dbf';
select t1.name,t2.name
from v$tablespace t1,v$datafile t2
where t1.ts# = t2.ts#;
