|
这里以linux下Oracle为例简要介绍一下使用 创建表空间并生成数据 sqlplus / as sysdba create tablespace hexiong datafile ?/hexiongdbf size M; create user hexiong identified by hexiong default tablespace hexiong; grant connect resource to hexiong; conn hexiong/hexiong create table t as select * from all_objects; 检查一下表空间是否齐备: exec sysdbms_ttstransport_set_check(hexiong TRUE); PL/SQL procedure successfully completed SQL> select * from systransport_set_violations; no rows selected 这表示该表空里的对象集是自包含的(对象及其索引都在此表空间中) 设定表空间为只读 alter tablespace hexiong read only; [] [] [] [] |
