如何创建表空间

create temporary tablespace user_temp
tempfile 'D:\oracle11\tablespace\user_temp.dbf'
size 500m
autoextend on
next 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;


CREATE TABLESPACE user_data
logging
datafile 'D:\oracle11\tablespace\user_data.dbf'
size 500M
autoextend on
next 32M maxsize 2048M
extent management local;

create user epmproject identified by epmproject
default tablespace user_data
temporary tablespace user_temp;

grant connect,resource,dba to epmproject;

RECID 行标识 guid - false
RECVER 行版本 long - false
DEPT_NAME 部门名称 nvarchar 20 false true
DEPT_MANAGER 部门经理 nvarchar 20 false true
DEPT_DATE 创建时间 date false true
DEPT_NUM 部门人数 numeric 10 0 false true
DROP TABLESPACE tablespace_name INCLUDING CONTENTS AND DATAFILES;
drop user ×× cascade

imp userid=XCZCGL0321_AID/XCZCGL0321_AID full=y file=d:/zcgl.dmp


回复表到某个点：
insert into gams_assetcardlock
select *
from gams_assetcardlock as of timestamp to_timestamp('20131022 11:40:00', 'yyyymmdd HH:mi:ss')


第 1 行出现错误:
ORA-01157: 无法标识/锁定数据文件 6 - 请参阅 DBWR 跟踪文件
ORA-01110: 数据文件 6: 'D:\TABLESPACE\SH_ZCGL.DBF'


SQL> alter database datafile 'D:\TABLESPACE\SH_ZCGL.DBF' offline drop;

数据库已更改。

SQL> alter database open;

查询oracle服务名：select global_name from global_name;