Oracle基础知识(持续更新)

C:\Users\Administrator>sqlplus /nologSQL*Plus: Release 10.2.0.3.0 - Production on 星期一 4月 11 22:07:37 2011Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.SQL> conn sys/admin as sysdba;已连接。SQL> create temporary tablespace user_temp  2  tempfile 'D:\oracle\oradata\Oracle10g\user_temp.dbf'  3  size 50m  4  autoextend on  5  next 50m maxsize 20480m  6  extent management local;表空间已创建。SQL> create tablespace user_data  2  logging  3  datafile 'D:\oracle\oradata\Oracle10g\user_data.dbf'  4  size 50m  5  autoextend on  6  next 50m maxsize 20480m  7  extent management local;表空间已创建。SQL> create user csdn identified by admin default tablespace user_data  2  temporary tablespace user_temp;用户已创建。SQL> grant connect,resource to csdn;授权成功。SQL> revoke resource from csdn;撤销成功。SQL> drop user csdn cascade;用户已删除。SQL> drop tablespace user_data including contents and datafiles;表空间已删除。SQL> drop tablespace user_temp including contents and datafiles;表空间已删除。