一些管理语句

exp yd/aaa file=F:/oracle_bak/20110223-1139.dmp  owner=(yd)

CREATE TABLESPACE YDGTTS
　　LOGGING
　　DATAFILE 'E:/app/Administrator/oradata/YDGTTS/YDGTTS.dbf' SIZE 500M
　　EXTENT MANAGEMENT LOCAL
   SEGMENT SPACE MANAGEMENT AUTO
单行：
CREATE TABLESPACE YDGTTS LOGGING DATAFILE 'E:/app/Administrator/oradata/YDGTTS/YDGTTS.dbf' SIZE 2048M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

imp yd/aaa  file=c:/20110223-1139.dmp  full=y  ignore=y

drop user yd cascade; 会删除此用户名下的所有表和视图。

-- Create the user
create user yd
  identified by "aaa"
  default tablespace YDGTTS;
-- Grant/Revoke role privileges
grant connect to yd;
grant dba to yd;

删除表空间：
DROP TABLESPACE YDGTTS INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;