oracle 11g express 快速入门

最新推荐文章于 2024-09-20 19:35:43 发布

转载最新推荐文章于 2024-09-20 19:35:43 发布 · 346 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/ystq/p/5959407.html

文章标签：

#数据库

创建表空间
CREATE TABLESPACE testdb LOGGING DATAFILE 'F:\oracle\app\oracle\oradata\XE\testdb.dbf' SIZE 100M AUTOEXTEND ON NEXT 32M MAXSIZE 500M EXTENT MANAGEMENT LOCAL;
create temporary tablespace testdb_temp tempfile 'F:\oracle\app\oracle\oradata\XE\testdb_temp.dbf' size 100m autoextend on next 32m maxsize 500m extent management local;
创建用户
CREATE USER testuser IDENTIFIED BY asdf1234 DEFAULT TABLESPACE testdb TEMPORARY TABLESPACE testdb_temp;
授权
grant connect,resource,dba to testuser;
grant create session to testuser;
创建表

create table users(
id number(9) not null primary key,
name varchar2(64) not null,
password varchar2(64) not null,
age number(3) default 10
)

删除表空间
DROP TABLESPACE testdb INCLUDING CONTENTS AND DATAFILES;
删除用户
drop user testuser cascade;
创建主键sequence
create sequence users_seq increment by 1 start with 1 MAXVALUE 999999 NOCYCLE NOCACHE;
SELECT users_seq.currval FROM DUAL;
INSERT INTO users VALUES (users_seq.nextval, 'sam');

转载于:https://www.cnblogs.com/ystq/p/5959407.html