SQL*Plus: Release 11.2.0.1.0 Production on 星期三 10月 26 16:57:05 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
请输入用户名: system/pass@db
连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> drop tablespace tbsp including contents and datafiles cascade constraints;
表空间已删除。
SQL>drop user us cascade;
SQL> create temporary tablespace tbsp_temp tempfile 'd:\oracle\Administrator\ora
data\orcl\tbsp_tmp.dbf' size 32m autoextend on next 32m maxsize 2048m extent man
agement local;
表空间已创建。
SQL> create tablespace tbsp logging datafile 'd:\oracle\Administrator\oradata\or
cl\tbsp.dbf' size 100m autoextend on next 32m maxsize 2048m extent management lo
cal;
表空间已创建。
SQL> create user Wadb identified by Wadb654321 default tablespace tbsp temporary
tablespace tbsp_temp;