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;表空间已删除。
