ORACLE相关：表空间序列索引分区游标存储过程分区等创建.docVIP

--创建表空间 create tablespace text datafile F:/db/ordata/hibernate/text.dbf size 10m AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; --创建用户 create user text identified by text default tablespace text --为用户分配权限 grant connect,resource,dba to text; --用户登录表的结构 create table street( id NUMBER(5) primary key not null, p_id NUMBER(5), name VARCHAR2(18) not null, constraint s_fk_p_id foreign key (p_id) references district(id) ); --创建表 create table district( id NUMBER(5) primary key not null, name VARCHAR2(18) not null ); -