Oracle数据库语句大全[参考].pdfVIP

Oracle 数据库语句大全 一．入门部分 1. 创建表空间 create tablespace schooltbs datafile ‘D:\oracle\datasource\schooltbs.dbf ’ size 10M autoextend on; 2. 删除表空间 drop tablespace schooltbs[including contents and datafiles]; 3. 查询表空间基本信息 select *||tablespace_name from DBA_TABLESPACES; 4. 创建用户 create user lihua identified by lihua default tablespace schooltbs temporary tablespace temp; 5. 更改用户 alter user lihua identified by 123 default tablespace users; 6