ORACLE建库模板

最新推荐文章于 2023-04-19 14:39:49 发布

oSherryLee

最新推荐文章于 2023-04-19 14:39:49 发布

阅读量1.4k

点赞数

分类专栏：数据库相关文章标签： oracle null table user cache

本文链接：https://blog.csdn.net/oSherryLee/article/details/8103449

版权

数据库相关专栏收录该内容

13 篇文章 0 订阅

订阅专栏

create temporary tablespace wtagc_temp
tempfile '/opt/oracle/oradata/orcl/wtagc_temp.dbf'
size 50M
autoextend on
next 50M maxsize 20480M
extent management local;

create tablespace wtagc_data
nologging
datafile '/opt/oracle/oradata/orcl/wtagc_data.dbf'
size 50M
autoextend on
next 50M maxsize 20480M
extent management local;

create user wtagc identified by sprixin
default tablespace wtagc_data
temporary tablespace wtagc_temp;

grant connect,resource to wtagc;

create temporary tablespace spagc_temp
tempfile '/opt/oracle/oradata/orcl/spagc_temp.dbf'
size 50M
autoextend on
next 50M maxsize 20480M
extent management local;

create tablespace spagc_data
logging
datafile '/opt/oracle/oradata/orcl/spagc_data.dbf'
size 50M
autoextend on
next 50M maxsize 20480M
extent management local;

create user spagc identified by sprixin
default tablespace spagc_data
temporary tablespace spagc_temp;

grant connect,resource to spagc;

drop sequence numseq;
create sequence numseq
    increment by 1
    minvalue 1
    maxvalue 9999999999999999
    cache 100;

drop table hspeedwayinfo;
create table hspeedwayinfo
(
id NUMBER(16) not null primary key,
name VARCHAR2(64) not null,
gpsxy VARCHAR2(64) not null unique,
sensornum1 number(16) not null,
sensornum2 number(16) not null,
virsennum number(16) not null
);